[TRAFODION-2586] UPSERT USING LOAD running slower than UPSERT with transactions disabled

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: any
• Fix Version/s: 2.2.0
• Component/s: sql-cmp
• Assignee: Suresh Subbiah
• Reporter: Suresh Subbiah
• Created: 11/Apr/17 01:19
• Updated: 15/Sep/18 07:32
• Resolved: 11/Apr/17 18:24

Description

Tricke loading with UPSERT USING LOAD was observed to be slower than trickle load with UPSERT and transactions disabled. For a table with no indexes the two runs should have performed equivalently.

This can be observed with ODB.

Issue Links

• links to: GitHub Pull Request #1059