Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #37752 > unrolled thread

Re: Cancel threads after timeout

Back to article view | Back to comp.lang.python

This discussion starts older than the indexed window; earlier articles aren't shown. The article labeled Started by below is the oldest one visible, not the original post.

Contents

  Re: Cancel threads after timeout Cameron Simpson <cs@zip.com.au> - 2013-01-27 11:34 +1100

#37752 — Re: Cancel threads after timeout

On 26Jan2013 09:48, Matt Jones <matt.walker.jones@gmail.com> 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.

Cheers,
-- 
Cameron Simpson <cs@zip.com.au>

Do not taunt Happy Fun Coder.

[toc] | [standalone]

Back to top | Article view | comp.lang.python

csiph-web