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:Polygonxmlns: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]> > 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]] *On Behalf Of *Marc-André > Trottier > *Sent:* Tuesday, November 29, 2011 5:06 PM > > *To:* [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
