[mapserver-users] Speeding up WFS paging with Spatialite and GeoPackage
Even Rouault
even.rouault at spatialys.com
Tue Dec 20 05:18:01 PST 2016
On mardi 20 décembre 2016 13:07:27 CET Rahkonen Jukka (MML) wrote:
> https://www.postgresql.org/docs/9.1/static/sql-declare.html
In the PostGIS case (I mean not through OGR PG driver), OFFSET and LIMIT are also used:
https://github.com/mapserver/mapserver/blob/branch-7-0/mappostgis.c#L1968
Postgres cursors can be used when you have a persistent connection and iterate through the
result set (that's what the OGR PG driver does in its GetNextFeature() implementation). But
WFS is state less, so that couldn't be used. Or that would require special code, that could
only work in fastCGI with defered connection closing, and likely some timeout mechanism to
be able to ditch cursors no longer being used, to be able to reuse a Postgres iterator among
several identical queries that would differ only by their STARTINDEX.
Even
--
Spatialys - Geospatial professional services
http://www.spatialys.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20161220/ba39981f/attachment.htm>
More information about the MapServer-users
mailing list