logo       
Google Custom Search
    AddThis Social Bookmark Button
-->

Re: Zope and psycopg create new processes again and again: msg#00068

Subject: Re: Zope and psycopg create new processes again and again
Il giorno mer, 14/09/2005 alle 15.02 +0200, Nico Grubert ha scritto:
> HI there,
> 
> I am having problems with Zope and psycopg-1.1.18. Somehow, a lot of 
> postgres processes are created during I use a Zope application that uses 
> 3 different ZPsycopg DA instances in Zope. Everytime I do an SQL INSERT, 
> UPDATE or SELECT, more and more proccesses are created.
> My Zope applications is an own Zope Product that uses just a few ZSQL 
> methods, 3 ZPsycopg Database adapters and 3 Postgresql databases.

This is rapidly becoming a FAQ (probably it was in the old FAQ that got
lost in the disk crash 1 year ago.) The number of connections created by
using ZPsycopgDA is equal to:

        number of Zope threads  x  number of ZPsycopgDA objects

Hope this helps,
federico

-- 
Federico Di Gregorio                         http://people.initd.org/fog
Debian GNU/Linux Developer                                
fog-8fiUuRrzOP0dnm+yROfE0A@xxxxxxxxxxxxxxxx
INIT.D Developer                                           
fog-NGVKUo/i/6DYtjvyW6yDsg@xxxxxxxxxxxxxxxx
                             Best friends are often failed lovers. -- Me

Attachment: signature.asc
Description: This is a digitally signed message part

_______________________________________________
Psycopg mailing list
Psycopg-IAPFreCvJWPBWskQ1e/+sw@xxxxxxxxxxxxxxxx
http://lists.initd.org/mailman/listinfo/psycopg
<Prev in Thread] Current Thread [Next in Thread>