+-------[ Federico Di Gregorio ]----------------------
|
| > connection, it is taken from a pool where each thread has just one
| > connection (I'm just realizing now that it would be better to have this
| > as an attribute of DA rather than a global module value, in order to
| > avoid sharing them between different ZPsycopg DA objects... however,
| > for the moment, it should work).
|
| ok, we can switch to this model. maybe it is also a better model but
| that does not explain the bug and I don't like old bugs hidden in the
| code waiting to bite you.
I wouldn't store it in the DA. You're stuck with the same problem you had
before. You either have to make it persistent which means your ZODB grows for
every connections change, or you have to make it non-persistent and you end up
with stuff being stored in threads like you have now.
A class global will be shared between different DA objects.
I would keep the connection pool outside of Zope instances, which means
keep it in the ZPsycopgDA module or keep it inside psycopg.
--
Totally Holistic Enterprises Internet| | Andrew Milton
The Internet (Aust) Pty Ltd | M:+61 416 022 411 |
ACN: 082 081 472 ABN: 83 082 081 472
|akm-WGB6tguolmcknD0PxoumJhCuuivNXqWP@xxxxxxxxxxxxxxxx| Carpe Daemon
|
