[OAK-4032] Performance issues on Oracle after introducing bulk updates

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Fix Version/s: 1.4, 1.4.0
• Component/s: rdbmk
• Assignee: Unassigned
• Reporter: Tomek Rękawek
• Created: 22/Feb/16 12:26
• Updated: 10/Mar/16 11:20
• Resolved: 24/Feb/16 14:19

Description

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.