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