OAK-2066 introduces bulk updates support for Mongo and RDB document stores. New feature is used in the Commit class to improve the performance. Due to bug OAK-3938, batch updates have been disabled for the Oracle DB - as a result, the bulk createOrUpdate() method applies changes sequentially on Oracle.
However, after the
OAK-3724, the Commit class sends all inserts using the new createOrUpdate() (rather than bulk create(), as it used to do). As a result, Oracle doesn't use bulk INSERTs anymore.
- check if
OAK-4027makes the new createOrUpdate() works on the Oracle. If so, require the new Oracle JDBC driver in the RDBDocumentStore.
- improve the fallback createOrUpdate() to insert documents in bulk and update them sequentially.