On mercredi 14 décembre 2016 13:16:47 CET Even Rouault wrote: > On mercredi 14 décembre 2016 12:00:01 CET Rahkonen Jukka (MML) wrote: > > Hi, > > > > I am using Mapserver 7.0 with GDAL 2.1.1, released 2016/07/07 > > I have Geopackage as source data: > > > > CONNECTIONTYPE OGR > > CONNECTION "/users/wms/data/vektorit/kiinteistot/palsta.gpkg" > > DATA "select * from palsta" > > Using DATA "palsta" should likely make the RTree to be used. The "SELECT > ..." case could probably be also improved in that case, but that depends on > whether the OGR driver supports efficient spatial filtering on a layer > resulting from a SQL SELECT (which should be the case in the GPKG case) > > The GPKG case could also potentially benefit from similar optimizations as > the ones I did recently for the Spatialite case (would require checking > that a recent enough Spatialite lib is available so that the ST_ operators > can be used).
FYI, I've just enhanced the OGR backend to have optimizations in the GPKG case similar to the ones of the Spatialite case (requires GDAL >= 2 and Spatialite >= 4.3). Note: I only dealt with the DATA "layer_name" case, not for SELECT... -- Spatialys - Geospatial professional services http://www.spatialys.com
_______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
