[Zope-DB] Re: ZSQL parallelism problem

Umberto Nicoletti unicoletti@prometeo.it
Thu, 31 Jul 2003 11:02:06 +0200


Hi Kent,
I think the problem you are experiencing is similar to one we also had 
and we could not solve.

I hope I won't start any war between zope/python and java supporters but 
our findings are that zope/python is simply worse when dealing with 
threads than Tomcat/Java.

You can follow our previous posts here:

http://news.gmane.org/onethread.php?group=gmane.comp.web.zope.database&root=%3Cbal8s1%24942%241%40main.gmane.org%3E

Regards,
Umberto


Kent Hoxsey wrote:
> I'm using Zope 2.6.1 to encapsulate a bunch of sql scripts my 
> group uses for ad-hoc queries. It's really sweet, and simplifies
> a lot of my support issues for them.
> 
> But I've noticed a performance issue, and have run out of ideas
> to try to fix it.  Basically, my Zope setup can only run two ZSQL
> queries at a time, and as soon as I start a second one, the 
> whole instance stops serving new requests until one of the ZSQL
> queries finishes.
> 
> These are long-running queries (a couple minutes at least), so
> it's not useful to have the server unavailable. While the sql
> is executing, the Zope server is basically asleep, so there are
> no loading problems. It seems like something is blocking that
> keeps Zope from doing any useful work.
> 
> The setup:
> Win2k
> Zope 2.6.1
> Python 2.1.3
> Oracle 9i client libraries
> 
> Options I've tried:
> More Zope threads - 20 (-t option on startup)
> More ZODB threads - 20 (changed source code)
> ZODBC DA
> DCOracle2 DA
> mxODBC and DA from egenix (even with multiple connections open)
> 
> Clearly, the server, database, and all intervening software are
> capable, I just can't get them configured correctly. Anybody
> have any ideas?
> 
> Thanks.
> Kent