I have been trying to think of any other data source that could benefit ?
Perhaps WMS cascade?
Even with patching this on geoserver I would like to see a GeoTools patch
for this very real performance issue with the oracle dialect of
JDBCDataStore.
On Tue, Mar 10, 2015 at 10:13 PM <[email protected]> wrote:
> Hi Andrea,
>
>
>
> It seem like there might be some confusion with the different oracle
> issues floating around. The oracle version(
> https://jira.codehaus.org/browse/GEOT-4912 ) issue has nothing to do with
> the patch Lingbo is suggesting on implementing. However to clear up the
> confusion, I have advised Lingbo to create appropriate Jira task and submit
> a proposal instead so that the issue can be discussed accordingly around
> the proposal instead.
>
>
>
> Thanks
>
> Victor
>
>
>
>
>
> *From:* Jiang, Lingbo (Digital, Marsfield)
> *Sent:* Wednesday, 11 March 2015 12:49 PM
> *To:* Tey, Victor (Mineral Resources, Kensington)
> *Subject:* FW: [Geoserver-devel] [ExternalEmail] Re: Propose to add an
> option for latLongBoundingBox range checking before database query.
>
>
>
>
>
>
>
> *From:* [email protected] [mailto:[email protected]
> <[email protected]>] *On Behalf Of *Andrea Aime
> *Sent:* Wednesday, 11 March 2015 1:50 PM
>
>
> *To:* Jiang, Lingbo (Digital, Marsfield)
>
> *Cc:* Rahkonen Jukka (MML); Jody Garnett; Geoserver-devel
>
>
> *Subject:* Re: [Geoserver-devel] [ExternalEmail] Re: Propose to add an
> option for latLongBoundingBox range checking before database query.
>
>
>
> On Sun, Mar 8, 2015 at 11:53 PM, <[email protected]> wrote:
>
> Hi Everyone,
>
>
>
> I am working a patch on the "Honour the configured BBOX" with geoserver
> wms module. And we found that the number of database queries could reduce
> significantly with the BBOX to filter out the useless query. And it do
> improve the performance lots.
>
>
>
> Hem... you found that it helps a lot in a particular Oracle version
> (according to other comments) and had the suggestion from two
>
> core developers and PSC members to try and do the fix in the Oracle data
> store.
>
> Sorry to pull seniority here, but you cannot just ignore the comments you
> don't like and go on your merry way, whatever
>
> comes out of a discussion needs an _agreement_ to move on with code.
>
>
>
> So could you please share why you think this must be done in a general
> way, as opposed to inside the Oracle store?
>
>
>
>
>
> So far, I am trying to put this BBOX application option into the
> configuration file. I noticed that there are few choice:
>
>
>
> 1. ApplicationContext.xml.
>
> 2. Wms.xml
>
> 3. Global.xml
>
>
>
> Could someone suggest that which one will better to suit and what’s best
> way to add this option. A code snippet will be even great.
>
>
>
> Neither of them, this kind of setting would have to go in resource.xml as
> it would be a per layer one, not all layers
>
> in an installation would be Oracle, or would have to be locked to a bbox
> (wfs-t layers definitely do not, poeple will add
>
> data out of the bbox you configured.
>
>
>
> 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
>
------------------------------------------------------------------------------
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
