[Zope] zope 'hangs' - queries only
Dieter Maurer
dieter@handshake.de
Thu, 13 Dec 2001 23:03:36 +0100
Stephan Herschel writes:
> ...
> I created now a test function wich just sleeps for 30 seconds.
> While this is running i can still work with zope in another session, but
> only if pages are displayed which don't contain sql-queries! All
> queries seem to wait until the sleep-job has ended!
>
> This seems very strange to me. Is this a problem of the DA? Or is it a
> problem of zope's threading mechanism? Please give me feedback.
To me too...
We know that the Interbase DA uses global locking, such that
two SQL queries cannot proceed in parallel (or interleaved).
But a "sleep" and an SQL query should not be coupled.
Dieter