[Zope-DB] Re: SQL Relay

[Kent Hoxsey]

Excellent point, this was one of the things that I thought originally to be causing
the problem. However, after increasing both the number of Zope threads as
well as the number of ZODB threads, Zope is still unable to execute more than
2 (long-running) ZSQL methods at one time.

Kent

-----Original Message-----
From: "Matthew T. Kromer" <matt at zope.com>

Keep in mind that there is a hidden limiter in Zope, being the number 
of ZODB threads available.  This thread count is different than -t, and 
you can't get concurrent threads needing ZODB objects higher than the 
number of ZODB threads.  If you have REALLY LONG running queries, you 
usually have to bump up both -t and the number of ZODB threads.  Newer 
zopes may do this with -t, I can't recall; it used to be you had to go 
in and modify the default storage mount parameters.