[Zope] zserver blocking behavior with a slow request

[Matt Hamilton]

Jim,
   What platform is this on? and is it a uni or multi-processor system. 
  I did a bit of studying a long time ago into performance of Solaris 
with python:

http://www.zope.org/Members/glpb/solaris

not sure how relevant it is now, but if you are running on an old 
solaris box there might be some hints there.

-Matt

Jim Abramson wrote:
> On a production Zope (2.7.6) running behind apache and connected to an 
> Oracle database,  I'm finding that once a user requests a page which 
> runs a particularly slow sql (say up to 5 minutes), any other subsequent 
> requests seem to take the hit as well, and return very slowly.
> 
> I have 8 zserver threads and a ZODB pool size of 10.  I'm fairly certain 
> I'm not maxing these out.  So is this blocking effect just expected 
> behavior for zope?  One point of note is that the requests passed from 
> apache all bear the remote ip of 127.0.0.1.  Could zserver be throttling 
> the incoming requests due to their identical REMOTE_IP (or some other 
> apache configuration detail)?  Is there anything else I should investigate?


-- 
Matt Hamilton                                       matth at netsight.co.uk
Netsight Internet Solutions, Ltd.        Business Vision on the Internet
http://www.netsight.co.uk                             +44 (0)117 9090901
Web Design | Zope/Plone Development & Consulting | Co-location | Hosting