i am trying to execute this update query in a vb.net application:
SQL = "UPDATE billing_calldata SET status = 'c', customer = '" & customer_sequence & "', description = '" & description & "', customer_cost = '" & customer_cost & "', customer_ac = '" & customer_ac & "', customer_sc = '" & customer_sc & "', reseller_cost = '" & reseller_cost & "', reseller_ac = '" & reseller_ac & "', reseller_sc = '" & reseller_sc & "' WHERE sequence = '" & sequence & "';"
but its taking ages and not even completing.
on the ExecuteNonQuery()
its saying:
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
what could be causing it to not complete?
i have copied the query (with the correct values) and tried to run directly on the server which takes about 49 secs (but it actually completes)
i have added an index on my sequence
column in the table
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…