[Zope] threading and database connections

[J Cameron Cooper]

>
>
>Using MySQL and Zope.  Anyone know what happens when more than one Zope
>thread wants to access MySQL (or any database) at the same time?  Do the
>database adaptors serialize?
>
Zope will serialize requests to the same connection so that threads will 
block, although specific behaviour may depend heavily on the DA. (With 
pooling, you may only get blocking under N-request conditions.)

You'll want to check the actual product for its characteristics. The big 
ones should be advanced enough to do thread pooling and transactions and 
be thread-safe.

http://zope.org/Members/adustman/Products/ZMySQLDA/view
http://zope.org/Members/adustman/Products/MySQLdb/view

And academically,
http://listserv.sap.com/pipermail/sapdb.general/2002-February/010557.html

          --jcc