[mapserver-users] wfs request getfeature with polygon

[Marc-André Trottier]

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) <Steve.Lime at state.mn.us>

>  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:* mapserver-users-bounces at lists.osgeo.org [mailto:
> mapserver-users-bounces at lists.osgeo.org] *On Behalf Of *Marc-André
> Trottier
> *Sent:* Tuesday, November 29, 2011 5:06 PM
>
> *To:* 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****
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20111130/c7cce2d5/attachment.html