Re: [pothompson] Speeding up viewers
Hi Paul,
It shouldn't take very long at all with 10,000 records. But it does depend on the web host. How many seconds is it?
You can add the following options to speed things up:
'loadUploads' => false, // won't load uploads
'loadCreatedBy' => false, // won't load values for record author user
And there is no automated way to create an index but you could do that with phpMyAdmin or MySQL Query Browser or something like that.
Also, I'm not sure how this query would return any results because a category couldn't be 10 and 34 and 78 at the same time. Did you mean OR?
Hope that helps!
Dave Edis - Senior Developer
interactivetools.com