[drupal-devel] LOCK vs. SELECT FOR UPDATE

[Khalid B]

If connections are on a per client, then I am with Moshe on this.

Let us do it The Right Way (TM).

On 9/29/05, Moshe Weitzman <weitzman at tejasa.com> wrote:
> > Without pconnect, the connection closes at the end of the script's
> > execution.  With pconnect, the connection stays open for use by a
> > subsequent request using that process.  Subsequent != concurrent, so
> > you shouldn't be seeing any race conditions or multiple processes  using
> > a connection at the same time.
>
> OK then. Lets ditch those home grown sequences and make use of
> auto-increment/serial/identity fields.
>