[gdal-dev] GPKG writing times

[Jakub Nowosad]

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
>