Hi
Looking through the archive I found the message below in regard of a
problem.
I'm not really sure I understand the issue around N or what do you mean
with "ZPsycopgDA Connection objects". I am using ZSQL methods to run
queries. Looking at the server process using "ps | grep postgres", it
looks to me that each of my zope instances gets 4 connections. For some
sites, I'd like to reduce that to 2, for other sites I'd like to
increase this.
So where do I configure N? Did you mean adding more "Z Psycopg Database
Connection" objects through the dropd-down "Add" menu in the ZMI? But
as I have to specify for each ZSQL object what connector to use, how
would that help improving availability of connections?
Or would the way to configure this be to change the number of threads
for a zope instance? (And any pointer where I can learn more about how
to do that would be appreciated as well.)
Zope 2.7.5
PostgreSQL 7.3.4
Python 2.3.5
Psycopg:
$Id: DA.py 618 2005-01-05 20:05:54Z fog $''' % database_type
__version__='$Revision: 1.20.2.14 $'[11:-2]
__psycopg_versions__ = ('1.1.17','1.1.18')
Thank you
DR
-- message from archive --
[Psycopg] question about connections, commits, cursors
Federico Di Gregorio fog at initd.org
Tue Feb 3 20:01:46 CET 2004
Il mar, 2004-02-03 alle 19:57, Nick Bower ha scritto:
> Hi. How do you configure the number of connections within the pool in
> Zope?
>
> I'm not using Python code as this thread discusses but am simply using
> ZSQL methods and a Psycopg connection and would like to investigate
> the effect of increasing the size of the connection pool for high
> loads. Is there a global configuration file as there seems to be no
> setting available in the properties tab.
zpsycopgda does not use the connection pooling (btw, connection pooling
in psycopg is deprecated). you get a maximum number of
N * M connections
where
N is the number of ZPsycopgDA Connection objects in zope
M is the number of zope threads
hope this helps,
federico
--
Federico Di Gregorio http://people.initd.org/fog
Debian GNU/Linux Developer fog at
debian.org
INIT.D Developer fog at
initd.org
I'm hung like Einstein and smart as a horse! --
Trottalemme
|
