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

[Lime, Steve D (MNIT)]

MapServer 7.0 should fix issues like this. A more general solution to the one presented in #4049 has been added to that version. You might try the development version and see how it goes.  I'm surprised simple queries aren't working well though since older versions of MapServer have optimizations specific to PostGIS for those simple cases. 

Steve

-----Original Message-----
From: mapserver-users-bounces at lists.osgeo.org [mailto:mapserver-users-bounces at lists.osgeo.org] On Behalf Of deduikertjes
Sent: Monday, November 03, 2014 9:56 AM
To: mapserver-users at lists.osgeo.org
Subject: [mapserver-users] WFS query slow on large postgis table (and small table disappointing as well)

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
mapserver-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users