On Thu, Feb 5, 2015 at 5:29 AM, <[email protected]> wrote:
> Hi Geoserver community,
>
> For every WMS layer that has latLongBoundingBox set up in the config,
> GeoServer may restrict the request to the configured latLongBoundingBox. At
> the moment, it doesn't, and this results in unnecessary query and wastes
> connections and cursors (for Oracle).
>
> Thus I propose to add an option in the code for latLongBoundingBox range
> checking. the option will allow to filter the none result query which is
> out of latLongBoundingBox range and improve the performance.
>
> If community reckon that it is the right way, I am willing to submit a
> code patch to implement it if necessary.
>
I would first understand better how the extra complexity is going to pull
its weight (because we'll have to maintain it,
and explain it to users).
A jdbc reader will open a connection for a very short amount of time, and
in normal situations you'd need to have a
very high load on empty areas to make the optimizations you're talking
about worthwhile... I fully understand there
is going to be a benefit, but is it going to be a 0.1% speedup, 1%, 10%?
If you take for example the usual wms shootout, you'll get almost nothing
out of it because most of the requests
are hitting areas where we have data, and the normal OGC/custom made
clients do the same as they respect the data boundaries
declared in the capabilities document.
Is it maybe related to the design of app-schema, which makes the reader
somehow hold to the connections and
resultsets for a longer time than normal simple feature usage?
Cheers
Andrea
--
==
GeoServer Professional Services from the experts! Visit
http://goo.gl/NWWaa2 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
*AVVERTENZE AI SENSI DEL D.Lgs. 196/2003*
Le informazioni contenute in questo messaggio di posta elettronica e/o
nel/i file/s allegato/i sono da considerarsi strettamente riservate. Il
loro utilizzo è consentito esclusivamente al destinatario del messaggio,
per le finalità indicate nel messaggio stesso. Qualora riceviate questo
messaggio senza esserne il destinatario, Vi preghiamo cortesemente di
darcene notizia via e-mail e di procedere alla distruzione del messaggio
stesso, cancellandolo dal Vostro sistema. Conservare il messaggio stesso,
divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od
utilizzarlo per finalità diverse, costituisce comportamento contrario ai
principi dettati dal D.Lgs. 196/2003.
The information in this message and/or attachments, is intended solely for
the attention and use of the named addressee(s) and may be confidential or
proprietary in nature or covered by the provisions of privacy act
(Legislative Decree June, 30 2003, no.196 - Italy's New Data Protection
Code).Any use not in accord with its purpose, any disclosure, reproduction,
copying, distribution, or either dissemination, either whole or partial, is
strictly forbidden except previous formal approval of the named
addressee(s). If you are not the intended recipient, please contact
immediately the sender by telephone, fax or e-mail and delete the
information in this message that has been received in error. The sender
does not give any warranty or accept liability as the content, accuracy or
completeness of sent messages and accepts no responsibility for changes
made after they were sent or for other risks which arise as a result of
e-mail transmission, viruses, etc.
-------------------------------------------------------
------------------------------------------------------------------------------
Dive into the World of Parallel Programming. The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net/
_______________________________________________
Geoserver-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-devel
