Hi,
According to an oracle admin eg. inserts could benefit from adding (oracle
specific) hints to the sql statements.
At this time I don't have funding/assignment to work on this, so this
message is to check if it would be something people would like to see/have.
I've looked at the private
org.geotools.jdbc.JDBCDataStore#buildInsertPS(InsertionClassifier kind,
SimpleFeatureType featureType, KeysFetcher keysFetcher,
PreparedStatementSQLDialect dialect) method [0] which generates the insert
prepared statement.
My idea would be to add some way eg. a Hints object maybe? or perhaps
the OracleDialect could be changed to provide the hint to add the /*+
APPEND_VALUES*/ hint to the sql statement so that:
INSERT INTO RSGBBGTITEST.OVERBRUGGINGSDEEL (
DAT_BEG_GELDH,DATUM_EINDE_GELDH,RELVE_HOOGTELIGGING,...) VALUES ( ?,?,?,...)
would become
INSERT /*+ APPEND_VALUES */ INTO RSGBBGTITEST.OVERBRUGGINGSDEEL (
DAT_BEG_GELDH,DATUM_EINDE_GELDH,RELVE_HOOGTELIGGING,...) VALUES ( ?,?,?,...)
more about direct-path insert hints in the oracle docs:
https://docs.oracle.com/cd/E11882_01/server.112/e25494/tables.htm#ADMIN01509
[0]
https://github.com/geotools/geotools/blob/master/modules/library/jdbc/src/main/java/org/geotools/jdbc/JDBCDataStore.java#L1802
Mark
--
Disclaimer;
This message is just a reflection of what I thought at the time of sending.
The message may contain information that is not intended for you or that
you don't understand.
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
GeoTools-Devel mailing list
GeoTools-Devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-devel
