[
https://issues.apache.org/jira/browse/OAK-4032?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Marcel Reutegger updated OAK-4032:
----------------------------------
Fix Version/s: (was: 1.4)
1.3.17
> 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.3.17
>
>
> 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)