Re: [Zope-dev] Zope threads on 2.7.0, python 2.3.3

2004-05-26 Thread Dario Lopez-Kästen
Heimo Laukkanen wrote: Hi, I am hitting my head agains wall - and witnessing strange behaviour, where after time most of load focuses only to one thread. I am not sure what is the cause of this, but so far we have seen different things before load has concentrated to one single thread. We also

Re: [Zope-dev] Zope threads on 2.7.0, python 2.3.3

2004-05-26 Thread Heimo Laukkanen
On Wed, 26 May 2004 08:09:53 +0200, Dario Lopez-Kästen [EMAIL PROTECTED] wrote: Heimo Laukkanen wrote: Hi, I am hitting my head agains wall - and witnessing strange behaviour, where after time most of load focuses only to one thread. I am not sure what is the cause of this, but so far we

Re: [Zope-dev] Zope threads on 2.7.0, python 2.3.3

2004-05-26 Thread Dario Lopez-Kästen
Heimo Laukkanen wrote: Do you use any DA, nad have long running SQL queries? Yes, extensively. We use DCOracle2 that had to be patched to work with UTF-8. And we combine it with badly scripted code too. We started to do prototype by using own Archetypes storage layer that stores data from

Re: [Zope-dev] Zope threads on 2.7.0, python 2.3.3

2004-05-26 Thread Heimo Laukkanen
On Wed, 26 May 2004 08:44:44 +0200, Dario Lopez-Kästen [EMAIL PROTECTED] wrote: We use a lot of queries (minimum 10-15) for each request, accros around 7 DA connected to various Oracle schemas. Most of the queries are fairsly simple, but there are a couple of queries that are often used

Re: [Zope-dev] Zope threads on 2.7.0, python 2.3.3

2004-05-26 Thread Dario Lopez-Kästen
Heimo Laukkanen wrote: On Wed, 26 May 2004 08:44:44 +0200, Dario Lopez-Kästen [EMAIL PROTECTED] wrote: Ok. In our case we use very simple queries, but this stupid code generates a lot of those. One thing to do is to throw away stupidity and Archetypes tsorage layer that is an bad idea - and

Re: [Zope-dev] Zope threads on 2.7.0, python 2.3.3

2004-05-26 Thread Chris Withers
Dario Lopez-Kästen wrote: Chris withers has done some work in improving DCOracle2's connections and general bug-fixning. If you haven't used it, grab the latest DCOracle2 from cvs - it is much better. My work is still on a branch... Have you tried cx_Oracle? No I was not aware that they had a

Re: [Zope-dev] Zope threads on 2.7.0, python 2.3.3

2004-05-26 Thread Dieter Maurer
Heimo Laukkanen wrote at 2004-5-25 22:46 +0300: ... What does Control_Panel -- Debug information tells you about the use of your connections (at the bottom of the page)? At the moment it said that only one opened connection and others were none. I have no terminal access to the machines at

[Zope-dev] Zope threads on 2.7.0, python 2.3.3

2004-05-25 Thread Heimo Laukkanen
Hi, I am hitting my head agains wall - and witnessing strange behaviour, where after time most of load focuses only to one thread. I am not sure what is the cause of this, but so far we have seen different things before load has concentrated to one single thread. After reading thread:

Re: [Zope-dev] Zope threads on 2.7.0, python 2.3.3

2004-05-25 Thread Dieter Maurer
Heimo Laukkanen wrote at 2004-5-25 14:54 +0300: ... witnessing strange behaviour, where after time most of load focuses only to one thread. ... After reading thread: http://www.gossamer-threads.com/lists/zope/dev/24230?page=last I started to wonder whether that signalling behaviour is also a

Re: [Zope-dev] Zope threads on 2.7.0, python 2.3.3

2004-05-25 Thread Heimo Laukkanen
On Tue, 25 May 2004 20:21:21 +0200, Dieter Maurer [EMAIL PROTECTED] wrote: I would be surprised... What does Control_Panel -- Debug information tells you about the use of your connections (at the bottom of the page)? At the moment it said that only one opened connection and others were none.