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- _______________________________________________ gdal-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/gdal-dev
