My 2 cents, DBCP is not usually recommended in the JEE environments where I have worked (mainly JBOSS) while c3p0 is usually highly recommended.
Simone. ------------------------------------------------------- Ing. Simone Giannecchini GeoSolutions S.A.S. Owner - Software Engineer Via Carignoni 51 55041 Camaiore (LU) Italy phone: +39 0584983027 fax: +39 0584983027 mob: +39 333 8128928 http://www.geo-solutions.it http://geo-solutions.blogspot.com/ http://simboss.blogspot.com/ http://www.linkedin.com/in/simonegiannecchini ------------------------------------------------------- On Tue, Jul 28, 2009 at 6:52 PM, Christian Müller<christian.muel...@nvoe.at> wrote: > I think that all deployments in a J2EE container should use the connection > pooling of the chosen container. > > I do not see the importance of a change but perhaps I have overseen > something. ? > > Andrea Aime writes: > >> 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 >> >> -- >> Andrea Aime >> OpenGeo - http://opengeo.org >> Expert service straight from the developers. > > > > ------------------------------------------------------------------------------ > 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 > Geotools-devel@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/geotools-devel > ------------------------------------------------------------------------------ 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 Geotools-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geotools-devel
