Thanks for the info guys. It looks like these might do the trick. -----Original Message----- From: Paul Browning [mailto:paul.browning@bristol.ac.uk] Sent: Thursday, May 02, 2002 10:55 AM To: Casey Duncan Cc: Jeff Nielsen / UgoFast; zope-dev Subject: Re: [Zope-dev] Threaded Database Access --On 02 May 2002 10:08 -0400 Casey Duncan <casey@zope.com> wrote:
ZPsycopgDA (for postgres) is definitely multi-threaded. I think zPopyDA is too.
http://www.zope.org/Members/glpb/solaris says:
The report also investigates in a cursory way the effects of adding a database adapter to the equation. A test was carried out to compare the effect of changing the threading model on a site doing queries against an Oracle database using DCOracle2. It was found that queries that involved writes on the database were forced to be completed in serial (this is unsuprising), whilst read requests could be carried out in parallel. In addition, ZSQL Methods have the ability to cache the rows they fetch from a database for a given query. The results show that caching of SQL queries can produce a significant performance
boost.
HTH Paul -- The Library, Tyndall Avenue, Univ. of Bristol, Bristol, BS8 1TJ, UK E-mail: paul.browning@bristol.ac.uk URL: http://www.bris.ac.uk/