I would be fine with straight switching. It seems we don't lose any functionality and if anything we gain some performance. Any down side?
I guess it might be nice to give the user the choice, allowing them to swap but not sure how much it gains us. And they can fall back on JNDI in such cases. So +1 on the straight switch. -Justin Andrea Aime wrote: > Hi, > I've been experimenting a little with connection pools performance > and it seems the C3P0 connection pool > (http://sourceforge.net/projects/c3p0/) > is designed for slightly better scalability than the DBCP one we're > using today. > > In particular in a WMS request benchmark, and when reaching the high > number of clients (40 threads against a pool of 20 connections) the pool > provides a 5-10% speed increase over a, which is not so bad given it's > just a library change. > > I would like to add it to the mix, just not sure how. > Shall we replace DBCP? Or give people another option, a list of > supported pools that does include DBCP and C3P0? > > The current connection options are pretty much supported by both > pools, thought C3P0 has more configuration knobs to offer. For > example, the connection validation can happen in a background thread > as opposed to doing every time a connection is extracted from > the pool. > > If anybody wants to try it out against PostGIS I've attached a quick > test for the NG datastore to this mail (non definitive, the > real thing should be probably moved to the core JDBC module so that > every JDBC datastore is affected). > > Cheers > Andrea > > > ------------------------------------------------------------------------ > > ------------------------------------------------------------------------------ > Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day > trial. Simplify your report design, integration and deployment - and focus on > what you do best, core application coding. Discover what's new with > Crystal Reports now. http://p.sf.net/sfu/bobj-july > > > ------------------------------------------------------------------------ > > _______________________________________________ > Geotools-devel mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/geotools-devel -- Justin Deoliveira OpenGeo - http://opengeo.org Enterprise support for open source geospatial. ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Geotools-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geotools-devel
