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.)
How does connection use work?
Thanks,
Jonathan
This transmission is intended for the named addressee(s) only and may contain sensitive or protectively marked material up to RESTRICTED and should be handled accordingly. Unless you are the named addressee (or authorised to receive it for the addressee) you may not copy or use it, or disclose it to anyone else. If you have received this transmission in error please notify the sender immediately. All email traffic sent to or from us, including without limitation all GCSX traffic, may be subject to recording and/or monitoring in accordance with relevant legislation.
On Tue, Oct 22, 2013 at 5:19 PM, Jonathan Moules <
jonathanmoules@anonymised.com> 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
--
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
-------------------------------------------------------
Hi Andrea,
Sorry, should have said; that was with TMS, through GeoServer (I do not have Enable direct integration with GeoServer WMS checked). I had my JavaScript client request a full screen of them.
I’d forgotten about the metatiling (mine are 4*4) - would that have made a different via this service?
Thanks,
Jonathan
This transmission is intended for the named addressee(s) only and may contain sensitive or protectively marked material up to RESTRICTED and should be handled accordingly. Unless you are the named addressee (or authorised to receive it for the addressee) you may not copy or use it, or disclose it to anyone else. If you have received this transmission in error please notify the sender immediately. All email traffic sent to or from us, including without limitation all GCSX traffic, may be subject to recording and/or monitoring in accordance with relevant legislation.
···
On 22 October 2013 16:29, Andrea Aime <andrea.aime@anonymised.com> wrote:
On Tue, Oct 22, 2013 at 5:19 PM, Jonathan Moules <jonathanmoules@anonymised.com> 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
–
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
On Tue, Oct 22, 2013 at 5:34 PM, Jonathan Moules <
jonathanmoules@anonymised.com> wrote:
Hi Andrea,
Sorry, should have said; that was with TMS, through GeoServer (I do *not*have Enable direct integration with GeoServer WMS checked). I had my
JavaScript client request a full screen of them.
I'd forgotten about the metatiling (mine are 4*4) - would that have made a
different via this service?
All tile oriented services provided by GWC use meta tiling to build the
tiles
Cheers
Andrea
--
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
-------------------------------------------------------
Interesting to know. Thanks for the explanation!
This transmission is intended for the named addressee(s) only and may contain sensitive or protectively marked material up to RESTRICTED and should be handled accordingly. Unless you are the named addressee (or authorised to receive it for the addressee) you may not copy or use it, or disclose it to anyone else. If you have received this transmission in error please notify the sender immediately. All email traffic sent to or from us, including without limitation all GCSX traffic, may be subject to recording and/or monitoring in accordance with relevant legislation.
···
Jonathan
On 22 October 2013 16:43, Andrea Aime <andrea.aime@anonymised.com> wrote:
On Tue, Oct 22, 2013 at 5:34 PM, Jonathan Moules <jonathanmoules@anonymised.com> wrote:
Hi Andrea,
Sorry, should have said; that was with TMS, through GeoServer (I do not have Enable direct integration with GeoServer WMS checked). I had my JavaScript client request a full screen of them.
I’d forgotten about the metatiling (mine are 4*4) - would that have made a different via this service?
All tile oriented services provided by GWC use meta tiling to build the tiles
Cheers
Andrea
–
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