timeout question

  • Thread starter Thread starter eric.goforth
  • Start date Start date
E

eric.goforth

Hello,

I have a connection string that looks like:

"SERVER=MyServer;DATABASE=MyDatabase;UID=Myuser;Connect Timeout=900;"

However, when I try to run the following, it times out after MUCH less
than 15 minutes:

Private Sub RunUpdateTransaction(ByVal UpdateSQL As String, ByVal
UpdateConn As SqlConnection)

Dim trnDeleteQuery As SqlTransaction =
UpdateConn.BeginTransaction(IsolationLevel.Serializable, "DeleteQuery")

Dim cmdDeleteQuery As New SqlCommand(UpdateSQL, UpdateConn,
trnDeleteQuery)

Try

Dim iUpdated As Integer

iUpdated = cmdDeleteQuery.ExecuteNonQuery

'trnDeleteQuery.Rollback()

trnDeleteQuery.Commit()

Catch ex As Exception
Throw ex
Finally
If Not cmdDeleteQuery Is Nothing Then
cmdDeleteQuery.Dispose()
If Not trnDeleteQuery Is Nothing Then
trnDeleteQuery.Dispose()
End Try

End Sub

My delete query looks like:

DELETE FROM Table1 WHERE MyID IN (1,2,3,4,5);
DELETE FROM Table2 WHERE MyID IN (1,2,3,4,5)

However, there are about 32000 values in my where.

Running a SELECT query in SQL Server Query Analyzer with the same WHERE
clause took about 8 minutes.

Thanks,
Eric
 
Connection Timeout is not the same as CommandTimeout

Set the cmdDeleteQuery.CommandTimeOut property to an appropriate value.
 
Back
Top