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


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

Re: Blocked thread

Started byChris Angelico <rosuav@gmail.com>
First post2014-07-18 04:21 +1000
Last post2014-07-18 05:01 +1000
Articles 3 — 2 participants

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: Blocked thread Chris Angelico <rosuav@gmail.com> - 2014-07-18 04:21 +1000
    Re: Blocked thread Marko Rauhamaa <marko@pacujo.net> - 2014-07-17 21:50 +0300
      Re: Blocked thread Chris Angelico <rosuav@gmail.com> - 2014-07-18 05:01 +1000

#74666 — Re: Blocked thread

FromChris Angelico <rosuav@gmail.com>
Date2014-07-18 04:21 +1000
SubjectRe: Blocked thread
Message-ID<mailman.11946.1405621301.18130.python-list@python.org>
On Fri, Jul 18, 2014 at 4:19 AM, Larry Martell <larry.martell@gmail.com> wrote:
> I do not think Oracle support async or non-blocking queries as
> Postgres does. But what I think I can do is not call join(), and just
> start monitoring the server when I kick off the thread with the mail
> sql it in.

It's more what the client library supports, rather than the server,
but sure. If it doesn't do async queries, that settles it.

ChrisA

[toc] | [next] | [standalone]


#74674

FromMarko Rauhamaa <marko@pacujo.net>
Date2014-07-17 21:50 +0300
Message-ID<87d2d3251r.fsf@elektro.pacujo.net>
In reply to#74666
Chris Angelico <rosuav@gmail.com>:

> It's more what the client library supports, rather than the server,
> but sure. If it doesn't do async queries, that settles it.

The server can't control that. At the networking/OS level, it's all
asynchronous.

I would recommend a process pool for blocking DB queries.


Marko

[toc] | [prev] | [next] | [standalone]


#74677

FromChris Angelico <rosuav@gmail.com>
Date2014-07-18 05:01 +1000
Message-ID<mailman.11952.1405623679.18130.python-list@python.org>
In reply to#74674
On Fri, Jul 18, 2014 at 4:50 AM, Marko Rauhamaa <marko@pacujo.net> wrote:
> Chris Angelico <rosuav@gmail.com>:
>
>> It's more what the client library supports, rather than the server,
>> but sure. If it doesn't do async queries, that settles it.
>
> The server can't control that. At the networking/OS level, it's all
> asynchronous.

That's what I mean. But if your client library doesn't support async
queries, it's not worth trying to hack it in. The "it" in the second
sentence was referring to "client library", not "server", though I
admit the grammar was a little unclear.

ChrisA

[toc] | [prev] | [standalone]


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


csiph-web