On Sun, Oct 15, 2006 at 06:43:43PM +0100, Lexington Luthor wrote: > With a bit of careful planning (and a few SELECT FOR UPDATE queries to > prevent deadlock), having perfect consistency and correct caching is > possible.
I didn't respond directly to this claim of yours. SELECT FOR UPDATE is only useful if I'm going to do SELECT. If I am using memcache, one would presume that I am using it in place of SELECT, to improve performance. If I'm going to SELECT and then memcache, I haven't gained anything. Cheers, mark -- [EMAIL PROTECTED] / [EMAIL PROTECTED] / [EMAIL PROTECTED] __________________________ . . _ ._ . . .__ . . ._. .__ . . . .__ | Neighbourhood Coder |\/| |_| |_| |/ |_ |\/| | |_ | |/ |_ | | | | | | \ | \ |__ . | | .|. |__ |__ | \ |__ | Ottawa, Ontario, Canada One ring to rule them all, one ring to find them, one ring to bring them all and in the darkness bind them... http://mark.mielke.cc/ ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org