[drupal-devel] LOCK vs. SELECT FOR UPDATE

Moshe Weitzman weitzman at tejasa.com
Fri Sep 30 00:55:24 UTC 2005

> 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.

More information about the drupal-devel mailing list