Andrea said: > on both installations i'm using DbConnectionPool module, > by Written by Warren A. Smith to allows to use a pool of mysql > connection in a more reliable way then standard webware dbpool > (it resumes a "closed" connection, useful when you have > a nasty firewal between webware and mysql). >
You may already realize this, but DbConnectionPool has no way of knowing if the connection that it has an internal reference to is really usable, so I'm not sure what you mean by 'resumes a "closed" connection'. My intent in writing DbConnectionPool was to only keep references to relatively "fresh" connections in the hopes that they really ARE usable. Anything that causes a connection to become unusable can still cause problems while that connection is still in the pool. As long as the "bad" connection is being handed out and "used" (attribute proxying), it will never expire because of "idleness", even though the connection is unusable for whatever reason. The maxAge expiration parameter was designed to help minimize the impact (and negative exposure) of this situation. A new maxUsage (name?) expiration parameter would also accomplish the same thing, but would be based on the number of times a (potentially "bad") connection has been acquired instead of the amount of time a (potentially "bad") connection has been in the pool. This would make the degraded service time window smaller for a more heavily loaded site, while sacrificing some performance benefits of having the pool in the first place. Please let me know if this is something that would be usefull for you. I think it would be fairly trivial to implement. Later. -- Warren Smith [EMAIL PROTECTED] ------------------------------------------------------- This SF.Net email is sponsored by BEA Weblogic Workshop FREE Java Enterprise J2EE developer tools! Get your free copy of BEA WebLogic Workshop 8.1 today. http://ads.osdn.com/?ad_id=5047&alloc_id=10808&op=click _______________________________________________ Webware-discuss mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/webware-discuss
