Do successive requests from the same web server reuse the same connection?
End of PHP script closes connection. If you have the knowledge to change DB layer to use pconnect then you certainly can (re) introduce LOCKing.
Someone with more knowledge of threaded MPM's and/or alternate platforms would have to pipe in on this, but with prefork apache, the connection is attached to a httpd child. 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. Allie Micka pajunas interactive, inc. http://www.pajunas.com scalable web hosting and open source strategies