[Geoserver-devel] Database Connections

A question to the experts:

Why is it that my Confluence installation on Tomcat rarely uses more than 2 concurrent database connections, while my Geoserver installation on the same Tomcat starts using 2 and gets as high as 6. Note that the Confluence is under quite a bit of load and the Geoserver is under basically none.

Paul

A question to the experts:

Why is it that my Confluence installation on Tomcat rarely uses more
than 2 concurrent database connections, while my Geoserver installation
on the same Tomcat starts using 2 and gets as high as 6. Note that the
Confluence is under quite a bit of load and the Geoserver is under
basically none.

Probably because they do better connection pooling than us? 6 does seem a
bit extreme though, when I last looked into this (which was a long time
ago), I thought we got it down to 2. One of the big problems we have is
the way a WFS response wants the bounds, because we have to calculate that
first, and then do the results. So it will always be at least two
connections per request. If there is a concurrent request then there's a
decent chance it will jump to 4. But yes, I imagine this could be
improved. Does udig have the same behavior, or is it just GeoServer?

Chris

Paul

-------------------------------------------------------
This SF.Net email is sponsored by: NEC IT Guy Games.
Get your fingers limbered up and give it your best shot. 4 great events, 4
opportunities to win big! Highest score wins.NEC IT Guy Games. Play to
win an NEC 61 plasma display. Visit http://www.necitguy.com/?r=20
_______________________________________________
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel

--