[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