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

[deduikertjes]

Steve,

Thank you for the suggestion. Mapserver 7 is an interesting option 
indeed. I cannot find a date when it is due. Do you have any knowledge 
of that?

I'm not looking forward to build mapserver from sources. I had not so 
good experiences with that in the past.
So I've been looking around in GitHub to find closed tickets which are 
related to the way the backend is queried or performance is improved.
I couldn't find any. Could you please point me to the relevant ticket(s)?

Thank you, MArco




On 03-11-14 19:06, Lime, Steve D (MNIT) wrote:
> 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