We use about 10 total database connections. We have 2 public clients and one 'admin' client. The 2 public clients use 7 zope threads and the admin one uses 4. So (10 x 7) x 2 plus (10 x 4) total mysql connections each time the whole thing starts up. Then if we kill off a dead client it leaves the old ones sleeping and connects new ones all over. We do that several times and our da connections of mostly all sleeping is a few hundred. The numbers may be off a bit but pretty close. This is what we are seeing. Allen Dieter Maurer wrote:
Chris Withers wrote at 2004-8-13 10:41 +0200:
... *sigh*
I'm starting to feel like I should see about migrating the changes I made for ZOracleDA into the ZOpe core and have all DA's use that way of doing things...
What do people think?
I never felt that the current way is wrong in any way.
You may get a few extra connections but unless you litter your site with redundant DA instances, that should not make a big problem.