[Zope] Re: Zope hangs when database takes too long to respond

2006-09-07 Thread Tres Seaver
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Sinang, Danny wrote: It is a known limitation of Zope, which has a set number of worker threads available to service user requests. If a worker thread blocks (e.g., waiting for MySQL), it is not able to do any work for other pending requests.

[Zope] Re: Zope hangs when database takes too long to respond

2006-09-06 Thread Tres Seaver
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Sinang, Danny wrote: Sorry for the typo error. The subject should read hangs, not hands . From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sinang, Danny Sent: Wednesday, September 06, 2006

Re: [Zope] Re: Zope hangs when database takes too long to respond

2006-09-06 Thread Jonathan
- Original Message - From: Tres Seaver [EMAIL PROTECTED] To: zope@zope.org Sent: Wednesday, September 06, 2006 5:16 PM Subject: [Zope] Re: Zope hangs when database takes too long to respond -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Sinang, Danny wrote: Sorry for the typo error

Re: [Zope] Re: Zope hangs when database takes too long to respond

2006-09-06 Thread Chris McDonough
On Sep 6, 2006, at 5:30 PM, Jonathan wrote: Another possible solution is to have a look at twisted: http://twistedmatrix.com/projects/core/documentation/howto/faq.html Unless he wants to rewrite his application, Twisted likely won't help, right? The OP may also want to see why his MySQL

Re: [Zope] Re: Zope hangs when database takes too long to respond

2006-09-06 Thread Jonathan
- Original Message - From: Chris McDonough [EMAIL PROTECTED] To: Jonathan [EMAIL PROTECTED] Cc: zope@zope.org Sent: Wednesday, September 06, 2006 5:40 PM Subject: Re: [Zope] Re: Zope hangs when database takes too long to respond On Sep 6, 2006, at 5:30 PM, Jonathan wrote: Another

Re: [Zope] Re: Zope hangs when database takes too long to respond

2006-09-06 Thread Chris McDonough
On Sep 6, 2006, at 5:47 PM, Jonathan wrote: Unless he wants to rewrite his application, Twisted likely won't help, right? Twisted is, as i said Another possible solution - yes it will require work to integrate, but it is still a potential solution. I don't like to tell people what to

Re: [Zope] Re: Zope hangs when database takes too long to respond

2006-09-06 Thread Jonathan
- Original Message - From: Chris McDonough [EMAIL PROTECTED] To: Jonathan [EMAIL PROTECTED] Cc: zope@zope.org Sent: Wednesday, September 06, 2006 5:50 PM Subject: Re: [Zope] Re: Zope hangs when database takes too long to respond On Sep 6, 2006, at 5:47 PM, Jonathan wrote: Unless he

Re: [Zope] Re: Zope hangs when database takes too long to respond

2006-09-06 Thread Chris McDonough
On Sep 6, 2006, at 5:54 PM, Jonathan wrote: Well, by those standards, I propose he look at Delphi too... ;-) Do you mean he should consult the Oracle? ;-) Sure, why not, while he's at it? ;-) We can probably even haul in Interbase. P.S. I really was trying to be helpful Sure, I

Re: [Zope] Re: Zope hangs when database takes too long to respond

2006-09-06 Thread Jonathan
- Original Message - From: Chris McDonough [EMAIL PROTECTED] To: Jonathan [EMAIL PROTECTED] Cc: zope@zope.org Sent: Wednesday, September 06, 2006 6:01 PM Subject: Re: [Zope] Re: Zope hangs when database takes too long to respond On Sep 6, 2006, at 5:54 PM, Jonathan wrote: Well

[Zope] RE: Zope hangs when database takes too long to respond

2006-09-06 Thread Sinang, Danny
It is a known limitation of Zope, which has a set number of worker threads available to service user requests. If a worker thread blocks (e.g., waiting for MySQL), it is not able to do any work for other pending requests. You can tweak the number of threads in your zope.conf file, via the