Thanks, Andrea. If we are desperate enough I will have to debug my way
into the depths of the SDE driver to see what's going on.
I see the MapServer discussion here:
http://osgeo-org.1560.x6.nabble.com/FW-mapserver-dev-Motion-Retire-SDE-Support-for-MapServer-7-0-td5186626.html
Doesn't look like a firm decision, but clearly the desire to dump SDE is
there. It seems ESRI is not interested in promoting the SDE client libs
either. So perhaps GeoServer will follow the same path (and good
riddance!) However, we have a lot of legacy SDE DBs, so we'll have to
think hard about whether to try and move them to Oracle or to try and fix
the driver issues.
On Tue, Mar 17, 2015 at 10:03 AM, Andrea Aime <andrea.a...@geo-solutions.it>
wrote:
> On Tue, Mar 17, 2015 at 5:50 PM, Martin Davis <mtncl...@gmail.com> wrote:
>
>> We have a GeoServer 2.6.0 connected to an SDE 10.2 backed by Oracle 11g.
>> One layer is a grid layer with about 10M rectangles in it. WMS peformance
>> against this layer is fine (a few seconds to draw about 100 features).
>> However, WFS queries against the layer are VERY slow (many minutes to
>> return even just 1 feature). This is for both queries using a BBOX and for
>> raw queries using only a MAXFEATURES parameter (even with a very low
>> setting - e.g MAXFEATURES=1)
>>
>> WFS queries against other SDE layers in the same instance are somewhat
>> faster, but the layers have much less data, so it's possible that they are
>> also impacted by the issue.
>>
>> Are there any known issues that might cause GeoServer SDE WFS queries to
>> be very slow?
>>
>>
> I believe no core developer has had access to a SDE server in quite some
> time, as a result, we had very little changes
> on it and knowledge about what works, what does not, is sparse.
> I see MapServer is in the same boat and they were voting on dropping
> native SDE support recently (I believe the motion actually passed).
>
> If you have access to a SDE instance, you're in much better position that
> anyone else I know to debug and rectify the issue (and to answer your
> question, no, no known issues that I'm aware of)
>
> 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-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
