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
