http://www.perlmonks.org?node_id=1014978


in reply to Perl Query Locks A MsSQL Database

Can you do the the same update in your databases' interface directly? Does it lock the table too?

Also you can try to enable tracing in DBI (see section TRACING in DBI), maybe you'll find something interesting in the traces.

Finally it might be a good idea to prepare the update query outside of the loop, and use placeholders.