Opened 7 years ago
Closed 7 years ago
#6606 closed defect (fixed)
OCI - driver doesn't recognize ogr2ogr -gt option
Reported by: | ilucena | Owned by: | ilucena |
---|---|---|---|
Priority: | normal | Milestone: | 2.2.0 |
Component: | OGR_SF | Version: | svn-trunk |
Severity: | normal | Keywords: | oracle |
Cc: |
Description
The driver does not take advantage of the ogr2ogr -gt option an can only load 100 each transaction. According to the code:
https://trac.osgeo.org/gdal/browser/trunk/gdal/ogr/ogrsf_frmts/oci/ogrocitablelayer.cpp#L1631
Other suggestions to improve performance during loading:
- Modified INSERT to INSERT /*+ APPEND */
- When creating table use nologging and nologging on sdo_geometry varrays
Change History (2)
comment:1 by , 7 years ago
comment:2 by , 7 years ago
Resolution: | → fixed |
---|---|
Status: | new → closed |
Closing since it seems to be fixed by r34826
Note:
See TracTickets
for help on using tickets.
Fixed r34826
I added three new Options to the OCI driver.
The existing create-option MULTI_LOAD has a default of 100 item per insert group, so I added a new create-option MULTI_LOAD_COUNT where that number can be increased freely.
MULTI_LOAD_COUNT is also a open-option for append/update operations.
I added another create-option, FIRST_ID, where users can define what would be the ID value of the first row loaded. That is very useful when there are concurrent process appending to the same table.
FIRST_ID is also a open-option that can be uses from append/updated.
Finally I added the create-option NO_LOGGING where user's can tell if they don't want the server to keep log of a table that doesn't received a lot of updates anyway.
About the ogr2gr -gt parameter:
That parameter doesn't improve performance as much as the MULT_LOAD does. All the "-gt" parameter does is to issue Commit and StartTransaction while MULTI_LOAD prepare and execute array insert statements. Both parameters can be used in combination.