[mapserver-users] Mapserver does not use the spatial index with GeoPackage

[Rahkonen Jukka (MML)]

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"

Geopackage is created with GDAL 2.2 with default options and it does have a spatial index. Unfortunately it seems that it is not utilized:


[Wed Dec 14 13:51:12 2016].928976 msOGRFileOpen(/users/wms/data/vektorit/kiinteistot/palsta.gpkg)...
[Wed Dec 14 13:51:12 2016].929040 OGROPen(/users/wms/data/vektorit/kiinteistot/palsta.gpkg)
[Wed Dec 14 13:51:12 2016].940209 msConnPoolRegister(palstat,/users/wms/data/vektorit/kiinteistot/palsta.gpkg,0x94a050)
[Wed Dec 14 13:51:12 2016].942224 msOGRFileWhichShapes: SQL = select * from palsta.
[Wed Dec 14 13:51:12 2016].947950 msOGRFileNextShape: Returning shape=0, tile=0
[Wed Dec 14 13:51:12 2016].948047 msOGRFileNextShape: Returning shape=1, tile=0
[Wed Dec 14 13:51:12 2016].948098 msOGRFileNextShape: Returning shape=2, tile=0
[Wed Dec 14 13:51:12 2016].948132 msOGRFileNextShape: Returning shape=3, tile=0
[Wed Dec 14 13:51:12 2016].948173 msOGRFileNextShape: Returning shape=4, tile=0
[Wed Dec 14 13:51:12 2016].948215 msOGRFileNextShape: Returning shape=5, tile=0
[Wed Dec 14 13:51:12 2016].948291 msOGRFileNextShape: Returning shape=6, tile=0
[Wed Dec 14 13:51:12 2016].948340 msOGRFileNextShape: Returning shape=7, tile=0
[Wed Dec 14 13:51:12 2016].948405 msOGRFileNextShape: Returning shape=8, tile=0
[Wed Dec 14 13:51:12 2016].948464 msOGRFileNextShape: Returning shape=9, tile=0

Is there something that I should do for forcing Mapserver/OGR to use the R-tree index?

-Jukka Rahkonen-

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20161214/4948b7b7/attachment.html>