update strategy

Ivan Krstic krstic at fas.harvard.edu
Sat Oct 8 07:36:54 PDT 2005

mrot wrote:
> Iam not experienced memcache user so maybe I make some mistake,
> maybe the key shouldn't be SQL queries....

If you're caching rows, key them in cache by table name and primary key,
e.g. 'users:13'. Trying to do it by storing queries is usually a bad
idea for a number of reasons (though it has its purposes), one of which
you've encountered, and another of which is that there exists an
infinite number of SQL queries that will return the same row, so you can
be storing tons of duplicate rows in cache at the same time for no good

Ivan Krstic <krstic at fas.harvard.edu> | 0x147C722D

More information about the memcached mailing list