iifedy / aseisql

Automatically exported from code.google.com/p/aseisql
0 stars 0 forks source link

Break the connection to the database to stop a heavy query. #52

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago
When you cancel a query can take a long time to respond and not always have
administrator permissions to kill the process.

The only option is to kill the process with Task Manager. 

You could add an icon to break the connection with the database?

Original issue reported on code.google.com by zluis0@gmail.com on 13 Oct 2009 at 4:48

GoogleCodeExporter commented 8 years ago
You could close the connection when a query is running? 

See any downside?

Original comment by zluis0@gmail.com on 20 Oct 2009 at 7:00

GoogleCodeExporter commented 8 years ago
I can't reuse connection if it's not disconnected correctly.

If you select "cancel all" (Esc) then query canceled very fast.
Is it not working for you?
--
You can ask DBA to create a stored procedure sp_kill (for example)
and give you rights to call it...

Original comment by daggett....@gmail.com on 1 Nov 2009 at 1:10

GoogleCodeExporter commented 8 years ago
Works well with select queries, but not with update queries (update, delete, 
insert).

--
The procedure is an excellent idea.

Thanks :)

Original comment by zluis0@gmail.com on 3 Nov 2009 at 6:25

GoogleCodeExporter commented 8 years ago
so, i close this issue

Original comment by daggett....@gmail.com on 4 Nov 2009 at 5:30