K J wrote:
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?
!DSPAM:8,46b2d02297611262164653!
Although off-topic, it'd be easy to implement memcached as the cache
back end for Smarty. See
http://smarty.php.net/manual/en/section.template.cache.handler.func.php.
However I'd question the gain unless you have tons of templates.
