« Return to Thread: How to delete lots of related keys at once

Re: How to delete lots of related keys at once

by BabyPunt :: Rate this Message:

Reply to Author | View in Thread

Why is everyone using memcache for the SQL query as a key?  That is what the query cache on your database is for.  You gain very little doing it this way, except now you have to manage the invalidation yourself, which the query-cache does for you.
 
I was wondering about this too, as I was seeing the query cache being just as fast.  What should qualify for memcache then?  I imagine html snippets which includes data already fetched.  However I'm already using Smarty, so I can't just grab the html and stuff it back to memcache, can I?
 
What are some good places to use memcache?
 

 

 « Return to Thread: How to delete lots of related keys at once