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|
The driver does not take advantage of the ogr2ogr -gt option an can only load 100 each transaction. According to the code:
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
|Status:||new → closed|
Closing since it seems to be fixed by r34826
Note: See TracTickets for help on using tickets.
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.