Page 1 of 1

Php and RAM

Posted: Mon Apr 01, 2013 1:21 pm
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 :)

Re: Php and RAM

Posted: Mon Apr 01, 2013 1:48 pm
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)?