[Geoserver-devel] Why ST_SRID cause Geoserver generated SQL query to run about 500x slower?

ianturton · January 10, 2014, 1:04pm

I just came across this question on GIS.SE http://gis.stackexchange.com/q/82368/79 - I wondered if any one here (Andrea?) knew anything about it?

Cheers

Ian

–
Ian Turton

Andrea_Aime4 · January 10, 2014, 1:16pm

On Fri, Jan 10, 2014 at 2:04 PM, Ian Turton <ijturton@anonymised.com> wrote:

I just came across this question on GIS.SE
http://gis.stackexchange.com/q/82368/79 - I wondered if any one here
(Andrea?) knew anything about it?

I believe this is happening because we don't have the native SRID in
geometry_columns
If missing, add it, and reset the config in GeoServer

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

-------------------------------------------------------