HomeActive Query BuilderStopping a long running query

Stopping a long running query


Hi,
We have tables that are over 30,000,000 rows. If a user runs an SQL against these it takes ages to run. Is there a way to abort/end/pause SQL queries that are already started ? Query Analyzer has a red STOP button for this, does this product have something similar ? Maybe in the full version ??
thanks
Dave | email
September 18 2007, 12:40 AM
Dear Dave,

Active Query Builder doesn't run SQL queries at all. It is not intended to to that. Active Query Builder is a component to parse, build and analyze SQL queries, and this is what it can do the best.

As far as I know, to implement the "red button" functionality, you should run your queries in a separate thread to have ability to stop execution anytime the user pushes the button.
Sergey Smagin | email
3 days, 23 hours since original post
This topic is closed