MySQL Forums
Forum List  »  Memory Storage Engine

Memory + query cache
Posted by: robert cuadra
Date: July 07, 2006 03:10PM

I have a table of top categories. It will contain at most 100 records. I was thinking of creating it nightly as a Memory table to increase speed. This table will be hit ALOT.

Now If I cache the select statements and results that come from this memory table will that increase the performance even more?

Or is it just a waste considering the result set is cached anyways?

Am I better off just using a regular myisam table and caching on demand with SQL_CACHE since the results are pretty static and only change nightly? This way The results and queries for the 100 records would live in the cache.

Or Am I nuts and going about this completely wrong :)

Responses and comments are much appreciated.

Options: ReplyQuote

Written By
Memory + query cache
July 07, 2006 03:10PM
July 14, 2006 09:08AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.