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