Re: Which query is best?

From: Rumpi Gravenstein <>
Date: Tue, 15 Dec 2009 10:06:44 -0500
Message-ID: <>

<snip>They have explained me that, they have a
SELECT .. FOR UPDATE and some other series of actions and then followed by

Question -- is the update intended to update a single row or a set of rows? If the answer is a single row, then there are other ... more optimistic ... ways to get the lock that don't involve using the FOR UPDATE clause.

Rumpi Gravenstein
Received on Tue Dec 15 2009 - 09:06:44 CST

Original text of this message