Page 1 of 1

Loading Data into Cache

Posted: Wed Jul 18, 2012 3:13 am
by gotornot
Hi All
I have a database with 1million products in and I'm finding no matter how i index it to be slow when getting results.
I have basically built a search engine that looks up the results.
Is their anyway of loading all this data which is less than 1gig into the ram (Cache) would that speed the searches up and then i could update it every 24 hours?

If the answer is yes.

Can someone point me in the right direction of how to achieve this using PHP.

Thanks :)

Re: Loading Data into Cache

Posted: Wed Jul 18, 2012 8:05 am
by social_experiment
What does the database structure look like