[Zope-DB] Writing a DA: connection pooling

[Daniel Dittmar]

It seems as if Zope is creating only one object for every Connection 
object, even when it is accessed by multiple threads.

Sychronizing on the connection object would work, but that doesn't 
really utilize both Zope and the database.

Would it work to have a dictionary from thread to database session in 
the DA object? How should .commit () and .rollback () be handled? By 
only committing the session for that thread (seems more likely) or by 
committing all the sessions?

Is there anything else that I have to be aware of?

Daniel

-- 
Daniel Dittmar
SAP Labs Berlin
daniel.dittmar at sap.com