#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 by , 10 years ago
Component: | default → Utilities |
---|---|
Milestone: | → 2.0 |
Resolution: | → fixed |
Status: | new → closed |
comment:2 by , 10 years ago
Milestone: | 2.0 → 1.11.0 |
---|
Note:
See TracTickets
for help on using tickets.
trunk r26961 "ogr2ogr: bump default value for -gt from 200 to 20000 (#5391)"