[Zope-DB] [Weakness] excessive demand on database connections

M.-A. Lemburg mal@lemburg.com
Tue, 11 Mar 2003 10:42:04 +0100


Dieter Maurer wrote:
> <http://collector.zope.org/Zope/844>
> 
> Do not open a connection in "__setstate__"!
> Do it, when the database is accessed for the first time.
> If something goes wrong then, you get a traceback describing
> the problem. Now, some requests unrelated to the database
> simply take excessive time without any indication with respect
> to the problem.

Good point.

I've always wondered why DAs have to do this
and only put the logic into the mxODBC Zope DA because
all other DAs seemed to do the same. We'll turn the lazy
connect into an option in one of the future releases.

-- 
Marc-Andre Lemburg
eGenix.com

Professional Python Software directly from the Source  (#1, Mar 11 2003)
 >>> Python/Zope Products & Consulting ...         http://www.egenix.com/
 >>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/
________________________________________________________________________
Python UK 2003, Oxford:                                     21 days left
EuroPython 2003, Charleroi, Belgium:                       105 days left