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. 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.



 The Library, Tyndall Avenue, Univ. of Bristol, Bristol, BS8 1TJ, UK

Zope-Dev maillist  -  [EMAIL PROTECTED]
**  No cross posts or HTML encoding!  **
(Related lists - )

Reply via email to