[Zope-DB] SQL Relay and _v_ variables
chrisw at simplistix.co.uk
Thu Oct 23 13:43:21 EDT 2003
Andreas Kaiser wrote:
> It comes with it´s own DA: ZSQLRelayDA.
Interesting to note that this DA doesn't use _v_ variables.
It opens a connection at the beginning of the transaction and closes when the
transaction is finalised or aborted.
This mirrors the pathalogical ZOracleDA case, except that it doesn't leak
connections as far as anyone has commented ;-)
I'm guessing the constant opening/closing of connections is slower than keeping
them around, but maybe not as slow as it would be, since by the looks of it, SQL
Relay will live on the web server, and should be designed to be quick and
lightweight to connect to.
Can anyone confirm this?
Who's using SQL Relay under high load with lots of database adapters in production?
More information about the Zope-DB