[mapserver-users] WFS query slow on large postgis table (and small table disappointing as well)

[deduikertjes]

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.