#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 Changed 14 months ago by ilucena

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.

comment:2 Changed 13 months ago by Even Rouault

Resolution: fixed
Status: newclosed

Closing since it seems to be fixed by r34826

Note: See TracTickets for help on using tickets.