From: Michel Pelletier [mailto:michel@digicool.com]
Tony McDonald wrote:
It's MySQL, but using the latest DA - I'm pretty sure I'm doing more than one query at a time as I set off a ZSQL query that takes 9 seconds from the MySQL command line, and then started to use aspects of the site that I *know* use MySQL lookups. BTW, the 9 second SQL query isn't used in the site! :)
Oh one more thing, I'm pretty certain that the MySQL DA serializes ALL requests because the MySQL library for python is not thread-safe.
Not Andy Dustmans MySQL DA. CodeCatalog.com is ver very fast, and it uses Andy's MySQL DA. Python wrote his own python libraries, specifically to make MySQL access thread safe. -- Martijn Pieters, Software Engineer | Digital Creations http://www.digicool.com | Creators of Zope http://www.zope.org | mailto:mj@digicool.com ICQ: 4532236 | PGP: http://wwwkeys.nl.pgp.net:11371/pks/lookup?op=get&search=0xA8A32149 -------------------------------------------