Loading Data into Cache

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
gotornot
Forum Commoner
Posts: 54
Joined: Fri Jul 31, 2009 2:30 am

Loading Data into Cache

Post 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 :)
User avatar
social_experiment
DevNet Master
Posts: 2793
Joined: Sun Feb 15, 2009 11:08 am
Location: .za

Re: Loading Data into Cache

Post by social_experiment »

What does the database structure look like
“Don’t worry if it doesn’t work right. If everything did, you’d be out of a job.” - Mosher’s Law of Software Engineering
Post Reply