[gdal-dev] Does GDAL use prepared statements with Spatialite?

Jukka Rahkonen jukka.rahkonen at mmmtike.fi
Mon Mar 10 05:23:22 PDT 2014


Hi,

I saw a blog about using prepared statements for bulk inserts into SQLite
http://blog.quibb.org/2010/08/fast-bulk-inserts-into-sqlite/

Results show that with prepared statements the inserts/second rate in the
test were at least 3 times better than with standard transactions
http://blog.quibb.org/wp-content/uploads/2010/07/inserts_per_second.png

Could prepared statements make similar boost for saving spatial data into
SQLite/Spatialite/GeoPackage? Or does GDAL SQLite/Spatialite driver already
utilize them?

-Jukka Rahkonen-



More information about the gdal-dev mailing list