Hi List, I'm experiencing real slow performance when doing WFS queries on a postgis table with about 1500000 records.
A simple spatial query (which features in a box) takes about 1 to 2 minutes. In postgis the same query takes less than a second. Same story for attribute queries. Indeed on a postgis table with some 60000 records things are still very very slow. WMS on the other hand is flying taking less than a second for rendering most tiles. By using the debug functions I see that mapserver fetches all features in the map extent (set at map level) and then starts filtering feature by feature which takes a long time. I found ticket http://trac.osgeo.org/mapserver/ticket/4049 which seems to be related. Is there any way to speed up this kind of WFS queries? Is there any progress on the ticket? Any help appreciated, MArco -- View this message in context: http://osgeo-org.1560.x6.nabble.com/WFS-query-slow-on-large-postgis-table-and-small-table-disappointing-as-well-tp5170988.html Sent from the Mapserver - User mailing list archive at Nabble.com. _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
