#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)"