Php and RAM

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

Php and RAM

Post by gotornot »

Hi All

I have a site that holds over 900k of products. I am searching on my db and its taking 10 seconds to search products and bring back results. I wondered if i stored the data in the ram the results would be instantanious.

Does anyone have any experience or could point me in the right direction of how to do this.

In an ideal world i would like the rsults to come back in aroun1/2 seconds.

Thanks for the help and advice in advance :)
User avatar
requinix
Spammer :|
Posts: 6617
Joined: Wed Oct 15, 2008 2:35 am
Location: WA, USA

Re: Php and RAM

Post by requinix »

You may need to move to a dedicated search server or service, like Sphinx, Solr, or even just using Google's custom search.

But it's probably worth a minute to take a look at how efficient your searching is now. What's the code? Have you examined the performance of the SQL query(ies)?
Post Reply