Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > Python > Re: Cancel threads after timeout

Thread Tools

Re: Cancel threads after timeout

Matt Jones
Posts: n/a
It sounds like your real problem is with your SQL query... Is that part of
this problem under your control? Can you break the query into smaller,
quicker, pieces that you can run in a reasonable amount of time?

If not, nesting threads might be your best programmatic solution. Heed
Jason's warning though that the SQL Server my still be working even if you
cancel an operation from the outside (which could compound your problem).

*Matt Jones*

On Sat, Jan 26, 2013 at 9:43 AM, Jason Friedman <(E-Mail Removed)> wrote:

> > Sometimes it happens that a query on one of the database servers
> > takes longer than expected and impedes the generation of this report
> > (that's right, the queries are ran sequential). What I am trying to
> > achieve is to parallelize the queries on each database server and to be
> > able to cancel one of them if it takes longer than X minutes.

> Only answering a small portion of your question ....
> Assuming you are able to figure out how to "cancel" a thread or
> process on your side, it is possible the database itself will not
> respect that. In other words, if you execute "SELECT ..." singly,
> outside of Python, and type CNTL-C, does your database quickly
> recognize you are no longer interested in the result set and stop its
> work?
> --

Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: Cancel threads after timeout dieter Python 0 01-27-2013 07:29 AM
Re: Cancel threads after timeout Cameron Simpson Python 0 01-27-2013 12:34 AM
Re: Cancel threads after timeout Jason Friedman Python 0 01-26-2013 03:43 PM
Cancel threads after timeout hyperboreean Python 0 01-26-2013 01:14 PM
HELP CANCEL CANCEL CANCEL Carmen Rosario Computer Support 7 04-06-2005 11:04 PM