[mapserver-users] wfs request getfeature with polygon

[Marc-André Trottier]

! 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/20111129/44e6b800/attachment.htm>