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 -- Spatialys - Geospatial professional services http://www.spatialys.com _______________________________________________ gdal-dev mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/gdal-dev
