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

Reply via email to