Re: overhead of ZEO connection
Sanjay Rao <[email protected]>
| Newsgroups | gmane.comp.web.zope.zodb |
|---|---|
| Message-ID | <[email protected]> |
How many connections can be assumed to be safe in that case. ? What if my application opens lots of connections(hundreds) ? On Tuesday, 10 May 2016 03:40:28 UTC+5:30, Tres Seaver wrote: > > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > On 05/08/2016 08:11 AM, Sanjay Rao wrote: > > > Thanks for reply. If pool size is 8 then is following true ? > > > > In application; there are some long running(may run more than a hour) > > threads. there are 8 such threads these 8 long running threads get > > all available 8 connections in pool > > > > There are some short duration threads also, which read/write in > > database. These short duration threads won't get connection until at > > least one of the long running thread does not release connection. > > The DB object is willing to create new connections if the pools is empty: > it will begin to warn about the overage in the log. > > > Tres. > - -- > =================================================================== > Tres Seaver +1 540-429-0999 [email protected] > <javascript:> > Palladion Software "Excellence by Design" http://palladion.com > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1 > > iQIcBAEBAgAGBQJXMQq4AAoJEPKpaDSJE9HY81IQAJuyUG8iSeEfUsND+odOjdwO > 9c9wqJfJa5kAqwgrK9GpIO7e1LEGhjJuPpZ8EbDz0F75IOLNi10a0KInUtxouuqA > KyyvxsLagpytYXEeH9iBakUeQuqAp1E6eVl/ceUKiCtR97eKgVTqu9v0SzwBe3bW > ClT+KIJPQ0LUqF/JQMEEvX1h5e9Rg+/MIdCkgA68MJKvJWmkQFUNQhXDv4lnCVgx > pzPxx6KnA3likvbs24CO6dZ22zZVDIC73vXYmxaF/VOrem8Lau+rRhnsHCCs5uJw > +4KWX/AgVO9k64trEF0QurINtmpAuqSFNIbRTHsIU8a/dp+06z4oC3ORmiBjjQFR > ik4bGDVwaKwC/8+4Wr5ybk48wi30lwGRXaAoVH/he+RvZt6gLBx3agsR+UIEo0rI > NseeggzKs176ntp5wmWSRoaDMevj5xnBIpmTDsqvgu7wOSRGL77nDab/CAdIuMIJ > U5BzrF0w280FxxZgx/iVYRl4JeZstfHQlyBngvO0FgJosOX5UDN13txuMgsRPMoW > eFzkWjFdUe77WW/kv8BWrykRztcrLoAaiPS/b6R9LMGywcfKyC1m2wP0u4aAiCfa > y5TyxwpANFKXEWIfAyDraRcDDCI/B6ujG6p1r7RUNxzAB75fTh+hdXLqi1dvNtoQ > MFZPaeHEk+0+tlRTudnb > =Qp3b > -----END PGP SIGNATURE----- > > -- You received this message because you are subscribed to the Google Groups "zodb" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.