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)
