Velocity Reviews - Computer Hardware Reviews

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

Thread Tools

Re: Cancel threads after timeout

Cameron Simpson
Posts: n/a
On 26Jan2013 09:48, Matt Jones <(E-Mail Removed)> wrote:
| 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?

Another option to investigate is whether you can ask the database itself
to limit the run time of a query. Of course, that will abort the query
but so does your proposed solution.

Another approach might be to simply run each query regularly (with a
pause between so the database is not spending its whole life running
your query). Snapshot each latest result. Compute your report from the
latest pair of snapshots at any given time on an independent schedule.
It may not be valid for what you need, but if it is then this decouples
you from the query time completely.

Cameron Simpson <(E-Mail Removed)>

Do not taunt Happy Fun Coder.
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 Matt Jones Python 0 01-26-2013 03:48 PM
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