Tom Worster wrote: > On 6/27/09 3:15 PM, "Daniel Kolbo" <kolb0...@umn.edu> wrote: > >> When a MySQL table is locked a php call of mysql_query() that requires >> that table will hang as the request blocks at the MySQL server until the >> table is unlocked. Is there a way to stop a mysql_query from hanging >> (by setting a time limit)? > > would it be possible to test for presence of the lock before issuing the > query that would block? if so, you could check the lock periodically until > your time limit is up. would achieve you you're looking for? > > > it would still be possible that after checking but before issuing the query the table's could be locked - albeit a much smaller chance.
Thanks for the input, dK -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php