avalon-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Berin Loritsch <blorit...@apache.org>
Subject Re: SELECT 1
Date Tue, 22 Jan 2002 13:33:44 GMT
Danny Angus wrote:

>>I had written a database pool last year which got around this problem by
>>keeping track of the last time the connection was released.  Then the
>>ping was only made if that time was greater than 5 seconds.  This made a
>>big difference by cutting the pings down to nil when the application is
>>heavily loaded.  The thinking is that when the queries are spaced close
>>together, the fact that the previous query was successful gives the same
>>information as the ping would, so it is not necessary.
> I would have thought that pinging the connection when it was idle would be
> preferable to pinging it just before it was needed (when you have less time
> to create a new one), and if it is busy then that is the best time to reduce
> unnecessary traffic.

That was my next planned optimization.


"They that give up essential liberty to obtain a little temporary safety
  deserve neither liberty nor safety."
                 - Benjamin Franklin

To unsubscribe, e-mail:   <mailto:avalon-dev-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:avalon-dev-help@jakarta.apache.org>

View raw message