[jira] [Created] (OAK-4032) Performance issues on Oracle after introducing bulk updates

["Tomek Rękawek (JIRA)" <ji...@apache.org>]

Tomek Rękawek created OAK-4032:
----------------------------------

             Summary: Performance issues on Oracle after introducing bulk updates
                 Key: OAK-4032
                 URL: https://issues.apache.org/jira/browse/OAK-4032
             Project: Jackrabbit Oak
          Issue Type: Bug
          Components: rdbmk
            Reporter: Tomek Rękawek
            Priority: Critical
             Fix For: 1.4


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.

Possible solutions:

* check if OAK-4027 makes 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.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)