Fwd: [Zope] Performance under load using SQL (Postgresql)

[Federico Di Gregorio]

Scavenging the mail folder uncovered Paolo Comitini's letter:
> 
> I seem to be able to kill Zope *very* easily (with about 5 requests/sec) if
> that request does a lot of SQL activity. Now, this activity is not
> avoidable, but that load is pretty puny.
> 
> Also, it doesn't just seem to die either - it seems to hang completely under
> some circumstances.
> 
> I'm using Postgresql (makes no different whether it's 7.0 or the 7.1RC1)
> with ZPoPyDA and/or psycopg - they both suffer from the problem. What
> happens is that the child threads of ZServer die, leaving me with the
> top-level process (doing a waitpid on it's child) and the child (doing a
> select on the PCGI socket)

hi,

	to test psycopg we did 10,000 requests (10 reqs per sec) and
zope+psycopg didn't show any problem. i don't know what happens with 
the HEAD from cvs (a lot of stuff changed) but i don't think you are
using that.

ciao,
federico

-- 
Federico Di Gregorio
MIXAD LIVE Chief of Research & Technology              fog@mixadlive.com
Debian GNU/Linux Developer & Italian Press Contact        fog@debian.org
              All programmers are optimists. -- Frederick P. Brooks, Jr.