Page 1 of 1

PHP + MySQL = Cache Problem

Posted: Tue Mar 05, 2013 1:59 am
by gotornot
Hi All

I have a site that is taking a bunch of feeds from other sites, normalizing the data into a product file. I also have a "Google" like search engine that a user can use to searh this data and get desired results.

I have nearly 1m products and it takes 1 user only approximately 10 seconds to search the data even though its thoroughly indexed. I heard putting the data in cache would be far quicker.

Is this true?

The size of the data is just under 600mb so i have plenty of RAM.

If this is true can someone please point me in the right direction to upload it in the cache and search on it.

Many thanks

Re: PHP + MySQL = Cache Problem

Posted: Tue Mar 05, 2013 4:30 am
by requinix
Caching only helps when you know what data you want to get. By definition, it can't help with a new search. (You could cache the search results for a query, though, but you still have to get the results.)

First let's take a look at that query. What is it? What's the output of an EXPLAIN on it?

Re: PHP + MySQL = Cache Problem

Posted: Tue Mar 05, 2013 10:28 pm
by Weirdan
1m rows / 10 seconds - sounds like a full table scan to me, unless you have really slow server. I've just tried full table scan on a slow server on a table with 75M rows - it took about 45 seconds.