Thanks for the info guys. It looks like these might do the trick.

-----Original Message-----
From: Paul Browning [mailto:[EMAIL PROTECTED]] 
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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED]  URL: http://www.bris.ac.uk/




_______________________________________________
Zope-Dev maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope-dev
**  No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope )

Reply via email to