[mapserver-users] wfs request getfeature with polygon

[Lime, Steve D (DNR)]

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/96bab47f/attachment.html