Opened 3 years ago

Closed 3 years ago

Last modified 3 years ago

#5391 closed defect (fixed)

Increase the default transaction size of ogr2ogr

Reported by: Jukka Rahkonen Owned by: warmerdam
Priority: normal Milestone: 1.11.0
Component: Utilities Version: unspecified
Severity: normal Keywords:
Cc:

Description

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.

Change History (2)

comment:1 Changed 3 years ago by Even Rouault

Component: defaultUtilities
Milestone: 2.0
Resolution: fixed
Status: newclosed

trunk r26961 "ogr2ogr: bump default value for -gt from 200 to 20000 (#5391)"

comment:2 Changed 3 years ago by Even Rouault

Milestone: 2.01.11.0
Note: See TracTickets for help on using tickets.