I would expect to see a bbox query using the bbox of your search shape. That would then identify candidate shapes, likely a much smaller set, for which actual intersection tests are done. I'll defer to the WFS devs for a bit more insight.
Steve From: Marc-André Trottier [mailto:[email protected]] Sent: Wednesday, November 30, 2011 12:28 PM To: Lime, Steve D (DNR); [email protected] Subject: Re: [mapserver-users] wfs request getfeature with polygon there is my POST : <wfs:GetFeature xmlns:wfs="http://www.opengis.net/wfs"; service="WFS" version="1.1.0" xsi:schemaLocation="http://www.opengis.net/wfs http://schemas.opengis.net/wfs/1.1.0/wfs.xsd"; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";><wfs:Query typeName="ms:MSSS_SGS_P" srsName="EPSG:32198"><ogc:Filter xmlns:ogc="http://www.opengis.net/ogc";><ogc:Intersects><ogc:PropertyName>geometry</ogc:PropertyName><gml:Polygon xmlns:gml="http://www.opengis.net/gml"; srsName="EPSG:32198"><gml:exterior><gml:LinearRing><gml:posList>-206501.9511156373 322690.6403888138 -222920.53608453833 315197.18794487417 -217872.36749086587 305166.3182788128 -205933.97268351325 315573.2833999051 -206501.9511156373 322690.6403888138</gml:posList></gml:LinearRing></gml:exterior></gml:Polygon></ogc:Intersects></ogc:Filter></wfs:Query></wfs:GetFeature> we got some performance issues with 4 millions features. 2011/11/30 Lime, Steve D (DNR) <[email protected]<mailto:[email protected]>> What exactly is the WFS filter being used? Only certain queries are done wholly in the database. Most often bbox tests are done in the database with other work done in MapServer. We hope to move more load off to the database eventually. Are you seeing performance issues? Steve From: [email protected]<mailto:[email protected]> [mailto:[email protected]<mailto:[email protected]>] On Behalf Of Marc-André Trottier Sent: Tuesday, November 29, 2011 5:06 PM 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] http://lists.osgeo.org/mailman/listinfo/mapserver-users
