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