[Zope-dev] Threaded Database Access

[Jeff Nielsen / UgoFast]

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/