[CAY-1976] Slow performance of DbMerger

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.0.M2
• Fix Version/s: 4.0.M2
• Assignee: Andrus Adamchik
• Reporter: Andrus Adamchik
• Created: 01/Dec/14 07:57
• Updated: 09/Dec/14 08:27
• Resolved: 09/Dec/14 08:27

Description

This is a consequence of CAY-1946 refactoring. DbMerger applies "includeTableName" only after full reverse-engineering of the DB. So on databases with lots of system tables invoking DbMerger.createMergeTokens(..) becomes prohibitively slow. This is visible with MergeCase subclasses when running unit tests on PostgreSQL and Oracle.

E.g. on PostgreSQL 'mvn clean verify' that previously took ~2 min on my laptop, is now taking 1 hour. On Oracle I could not even finish the test run.

There is actually a TODO in DbMerger, line 178:

if (!includeTableName(tableName)) {
// TODO we have to cut this entities in db loader
// TODO log
continue;
}

We need to address this one.