Re: [gdal-dev] OGR Spatialite driver and spatial index

2011-08-29 Thread Even Rouault
Selon Jukka Rahkonen : > Hi, > > > ogrinfo OSM_Finland.sqlite -sql "select geometry, osm_id ,highway,ref, > name, tunnel from osm_line where highway is not null > AND MBRIntersects(geometry, BuildMBR(389116,6677305,389579,6677661))" The MBRIntersects() stuff is exactly what the OGR driver does, w

[gdal-dev] OGR Spatialite driver and spatial index

2011-08-29 Thread Jukka Rahkonen
Hi, Does the OGR SQLite/Spatialite driver really utilise the spatial index if such exists in the Spatialite database? The documentation suggests so http://gdal.org/ogr/drv_sqlite.html. However, I haven't been able to see any difference in my speed tests with ogr yet. I made a set of tests with o