Frederik Ramm wrote > Hi, > > while what I wrote in the previous post is still interesting and a > bit strange, I have meanwhile upgraded to GDAL 2 packages from the > ubuntugis-unstable repository for Xenial, and now the behaviour is as I > would expect it: The ogr2ogr -spat command *with* indexes takes > practically no time (0.05 seconds), and the -spat command *without* > index takes about 40 seconds as before. > > Sorry for the noise then. > > Bye > Frederik
Hi Frederik, Did you also notice that your no-index.sqlite database is not a SpatiaLite database but a SQLite db with FDO geometries? You can check it with ogrinfo: ogrinfo no-index.sqlite -sql "select CheckSpatialMetadata()" The return values are explained in the Spatilite SQL reference http://www.gaia-gis.it/gaia-sins/spatialite-sql-latest.html I do not know how FDO vs. Spatialite speeds differ in non-indexed searches but I guess you prefer making controlled tests by change only one thing at a time. -Jukka Rahkonen- -- View this message in context: http://osgeo-org.1560.x6.nabble.com/gdal-dev-SQLite-driver-hit-and-miss-with-spatial-index-tp5316090p5316200.html Sent from the GDAL - Dev mailing list archive at Nabble.com. _______________________________________________ gdal-dev mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/gdal-dev
