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.
