On Tue, Oct 22, 2013 at 5:19 PM, Jonathan Moules <
[email protected]> wrote:

> Hi List,
>   I've set up my GeoServer Oracle connection with the following:
>
> Max connections: 75
> Min connections: 5
> fetch size: 1000
> connection timeout: 20
>
> ---
>
> We discovered that when I pan to a new area which needs a lot of new tiles
> to be rendered, while there are requests for about 16 tiles sent to
> GeoServer, GeoServer only uses two "active" connections to ask Oracle for
> the data. Shouldn't it use more Oracle connections if they're available?
> (This is the test system, so no-one else is using them.)
>

Depends. Are you using GWC? If so, that in turn builds tiles via metatile,
the default metatilng factor
being 4x4, so one big request to WMS for 16 tiles.
You're probably hitting two nearby metatiles.

If you are doing WMS requests with tiled=true instead GeoServer does an on
the fly 3x3 metatile,
which might result in the same effect

Cheers
Andrea

-- 
==
Our support, Your Success! Visit http://opensdi.geo-solutions.it for more
information.
==

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054  Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39  339 8844549

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

-------------------------------------------------------
------------------------------------------------------------------------------
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from 
the latest Intel processors and coprocessors. See abstracts and register >
http://pubads.g.doubleclick.net/gampad/clk?id=60135991&iu=/4140/ostg.clktrk
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Reply via email to