[mapserver-users] wfs request getfeature with polygon

[Smith, Michael ERDC-CRREL-NH]

Marc-André ,

Try setting the ows_extent metadata parameter for the layer (you can make it world extents). MapServer, when it doesn't know the extents of a layer will issue a query to get those extents and it can be quite expensive for some layers. So you can populate your metadata with the extents to avoid this lookup.

Mike

--
Michael Smith
US Army Corps
Remote Sensing GIS/Center


From: Marc-André Trottier <marcandre_trottier at hotmail.com<mailto:marcandre_trottier at hotmail.com>>
Date: Tue, 29 Nov 2011 18:05:46 -0500
To: <mapserver-users at lists.osgeo.org<mailto:mapserver-users at lists.osgeo.org>>
Subject: [mapserver-users] wfs request getfeature with polygon


! i'm doing a WFS GetFeature request with a polygon.
Usually everything is fine.
but for one table a got a enconding error with my data. (my problem) and the mapserver's log give me this SQL :

select "nom","adresse","postal","code","telephone","postal0","etab_code","etab_nom","rss_code","rss_nom","rls_code","rls_nom","clsc_code","clsc_nom","mun_code","mun_nom","longitude","latitude","sgs","hsld","clsc","pdi","pdp","pat","cj","sp","objectid","nom_commun",encode(ST_AsBinary(ST_Force_2D("geom_p"),'NDR'),'hex') as geom,"objectid" from msss_v_sgs_p where geom_p && GeomFromText('POLYGON((-1100000 -23500,-1100000 2253500,1100000 2253500,1100000 -23500,-1100000 -23500))',find_srid('','msss_v_sgs_p','geom_p'))

So my question, Why is mapserver does a spatial query with the layer's extent?
with a table of 2millions features, that,s very slow even with a spatial index

marc-andre trottier

_______________________________________________ mapserver-users mailing list mapserver-users at lists.osgeo.org<mailto:mapserver-users at lists.osgeo.org> http://lists.osgeo.org/mailman/listinfo/mapserver-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20111130/f9220a75/attachment.html