OCI - driver doesn't recognize ogr2ogr -gt option

[ilucena]

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

[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.

[Even Rouault]

Closing since it seems to be fixed by r34826