[mapserver-users] querying WMS layer / WFS reprise

[Gregor Mosheh]

Daniel Morissette <dmorissette at dmsolutions.ca> wrote:

> MapServer's uses internal queries for GetFeature WFS requests, and a
> performance problem with MapServer queries on large PostGIS layers has
> been discussed on this list and on the chameleon lists in the last few days.
> It turned out that adding some indexes improved the query performance a
> lot. I don't know the details, hopefully others can comment or you can
> find them in the archives.

Ah, yes!  oid indexes. I just noticed those were missing yesterday, and
created them, *after* I did my WFS experimentation.

And you know what, it makes a big difference!

Thanks, Dan. You're awesome. :)