Andrea Aime ha scritto:
> 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.
To add another data point I run the Oracle tests with c3p0 and with
BDCP. The tests are not the high load kind, they can run with a handful
of connections, no parallelism, so it's a bit surprising to see any
difference in the test time. But it's undeniably there (run the
builds a few times to make sure).
Building Oracle module with tests and C3P0 connection pool:
[INFO]
------------------------------------------------------------------------
[INFO] BUILD SUCCESSFUL
[INFO]
------------------------------------------------------------------------
[INFO] Total time: 2 minutes 6 seconds
[INFO] Finished at: Wed Jul 29 11:58:44 CEST 2009
[INFO] Final Memory: 19M/117M
[INFO]
------------------------------------------------------------------------
Building Oracle module with tests and DBCP connection pool:
[INFO]
------------------------------------------------------------------------
[INFO] BUILD SUCCESSFUL
[INFO]
------------------------------------------------------------------------
[INFO] Total time: 2 minutes 14 seconds
[INFO] Finished at: Wed Jul 29 11:53:14 CEST 2009
[INFO] Final Memory: 18M/117M
[INFO]
------------------------------------------------------------------------
Cheers
Andrea
PS: yes, both are stupidly slow. The postgis tests are twice as much
(since postgis has both the prepared statemetn and the non ps paths
and runs most tests with both) and take slightly less time than
that. We need to do something about it, in particular have the
read only tests perform the setup just once.
--
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-devel
