Locking tables on persistent connections

From: Date: Wed, 06 Sep 2000 20:07:02 +0000
Subject: Locking tables on persistent connections
Groups: php.db 
Request: Send a blank email to php-db+get-2669@lists.php.net to get a copy of this message
Are there any issues to be aware of when using LOCK TABLES <table> WRITE when using persistent connections? What would happen if for some reason the process was to die before it reached UNLOCK TABLES? Would that persistent connection no longer be able to talk to the table that I locked? Our previous developer had run into a bug with this scenario, I am no longer able to contact him to find out what that bug was, but he moved to non-persistent connections to solve the problem. At our current load, this is no longer an acceptable alternative...the connections are just too expensive now. Thanks Bob Silva Lead Developer Bravenet Web Services www.bravenet.com

« previous php.db (#2669) next »