S
saqib
I have a query that is running on a mssql DB that takes about 15
minutes when run "directly"; IE: thru MS SQL Query Analyzer. I know, it
sucks. I'm trying to fix it.
But in the meantime, I have a python process which connects to the DB
using pymssql. This process runs the aformentioned query... but fails
because the query times out after approx 30 seconds. Is there anyway to
change/set the timeout setting on a pymssql DB connection?? I poked
around a bit in the pymssql module but nothing was obvious to me.....
-Saqib
minutes when run "directly"; IE: thru MS SQL Query Analyzer. I know, it
sucks. I'm trying to fix it.
But in the meantime, I have a python process which connects to the DB
using pymssql. This process runs the aformentioned query... but fails
because the query times out after approx 30 seconds. Is there anyway to
change/set the timeout setting on a pymssql DB connection?? I poked
around a bit in the pymssql module but nothing was obvious to me.....
-Saqib