Thank you. I'm going to post your answer in the issue.


On 10/15/2017 03:29 PM, Even Rouault wrote:
On dimanche 15 octobre 2017 10:16:35 CEST Jakub Nowosad wrote:
Hi,

I'd like to draw your attention to the case of slow (comparing to .shp)
writing times of GPKG.
See https://github.com/r-spatial/sf/issues/470 for the details and some
benchmarks.

Jakub,

A quick search in the code shows that sf doesn't use
OGRLayer::StartTransaction() / CommitTransaction() to surround calls to
CreateFeature(). By default, SQLite auto-commits each INSERT, which is slow.
Doing insertion by batches within a single (or several) transactions helps a
lot.

Even


_______________________________________________
gdal-dev mailing list
[email protected]
https://lists.osgeo.org/mailman/listinfo/gdal-dev

Reply via email to