[mapserver-users] Speeding up WFS paging with Spatialite and GeoPackage

[Even Rouault]

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.html>