Stopping a Long Running Query

  • Thread starter Thread starter Kory
  • Start date Start date
K

Kory

How do you stop a long running query with a SQLConnection or SQLCommand?

Calling Close on either just waits until the query is done. Is there a way
to stop it?
The following on a long query


SqlConnection mySqlConnection = new
SqlConnection("server=(local)\\NetSDK;Trusted_Connection=yes;database=northw
ind");
mySqlConnection.Open();
SqlCommand mySqlCommand = new SqlCommand("select * from employees order by
EmployeeID", mySqlConnection);

SqlDataReader myReader = mySqlCommand.ExecuteReader();

myReader.Close();

mySqlConnection.Close();
 
If you know the duration of time that defines 'long running' you cna set the
CommandTimeout property to that number + 1.

Before you do this though, make sure it's not the connection that's causing
the delay or the sheer number of records.

HTH,

Bill
 
The timeout isn't adequate because the record set can vary dramatically from
2-3 million records to 70-80 million, so it could run either for a minute or
3 hours...

Think of it as the ability to cancel a query. Right now, if you close it,
It waits there until the query is done.

There has to be (or sure should be ) a way to cancel a running query..
 
Noone has ever had to cancel a running query?

Kory said:
The timeout isn't adequate because the record set can vary dramatically from
2-3 million records to 70-80 million, so it could run either for a minute or
3 hours...

Think of it as the ability to cancel a query. Right now, if you close it,
It waits there until the query is done.

There has to be (or sure should be ) a way to cancel a running query..



SqlConnection("server=(local)\\NetSDK;Trusted_Connection=yes;database=northw order
Click to expand...
 
Back
Top