[Zope-DB] SQL Relay and _v_ variables

[Chris Withers]

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?

cheers,

Chris