Loading Data into Cache

[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 🙂

[Bunkermaster]

What you're trying to achieve is easily doable by mysql itself but depends a lot on different things.
- the engine you use for your tables
- the version of mysql
- the setup of the database server (MAMP,WAMP,XAMP, standalone, etc.)
- the cache settings on the mysql instance
- the other queries that run on your server
- the state sharding/partitioning of your table(s)
- etc.

You will need to be more precise I'm afraid.

[gotornot]

Do you know where i would find that out?

[Bunkermaster]

What you need to do is:
1) find out is where the bottleneck is.
2) fix it
3) test performances against requirements
4) if !good, go to 1)

[dalecosp]

Is this reading helpful?