php - Porting SQL results into memcached -

I have some tables that are often accessed by users, the same type of queries are repeatedly running, But the additional burden is caused.

Records often do not include / update frequently, I was thinking of memcached to campaign ID and then used to get them from the database would reduce the burden of search / sorting etc.

Here is an example

  P from SELECT P.product_id products, product_category C WHERE P.cat_id = C.cat_id and CCT_name = 'fashion' and PIS_product_activ = True and CICA Cact_Active = P.Product_Date The correct order by DESC  

The above questions will return all product IDs in a particular category and will be imported into Memcached The process (i.e., paging) will be duplicated in the same way as we do with mysql result sets

The insertion process will either end the cache or the first line of the array to the product ID.

My question is this practical apporach? How do people deal with searches, if someone is searching for a product that returns 10000 results (not practically possible) then they search the tables all the time? Is there any good example of Memkachand and Miskel that shows how this work can be done?

You

Usually a 5 minute cash product list may be acceptable for is.

If your invalid plan is time-based only (new entries will only appear after 5 minutes) is a quick and dirty trick that you can use with memcache: just copy your SQL query string Use it as an MMDI, and tell memcache to keep its results for 5 minutes.

I hope this will help you