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 <[email protected]<mailto:[email protected]>> Date: Tue, 29 Nov 2011 18:05:46 -0500 To: <[email protected]<mailto:[email protected]>> 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 [email protected]<mailto:[email protected]> http://lists.osgeo.org/mailman/listinfo/mapserver-users
_______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
