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
_______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
