Increase the default transaction size of ogr2ogr
|Reported by:||Jukka Rahkonen||Owned by:||warmerdam|
Ogr2ogr is using 200 rows as a default size for transactions. This feels all too small value and it slows down database operations. For example, I measured that converting a test dataset into GeoPackage format took 131 minutes with the default transaction size but only 18 minutes when I increased the size of transactions into 20000 rows.
It is possible to increase the size of transaction with the -gt option. However, many users use ogr2ogr with default settings and it would be better to use for example 20000 rows as a default size that could be decreased if needed.