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.
|Replies are listed 'Best First'.|
Re^2: Perl Query Locks A MsSQL Database
by EEddieEmm (Initiate) on Jan 23, 2013 at 18:43 UTC