You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@trafodion.apache.org by "Suresh Subbiah (JIRA)" <ji...@apache.org> on 2017/04/11 01:19:42 UTC

[jira] [Created] (TRAFODION-2586) UPSERT USING LOAD running slower than UPSERT with transactions disabled

Suresh Subbiah created TRAFODION-2586:
-----------------------------------------

             Summary: UPSERT USING LOAD running slower than UPSERT with transactions disabled
                 Key: TRAFODION-2586
                 URL: https://issues.apache.org/jira/browse/TRAFODION-2586
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-cmp
    Affects Versions: any
            Reporter: Suresh Subbiah
            Assignee: Suresh Subbiah
             Fix For: 2.2-incubating


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.





--
This message was sent by Atlassian JIRA
(v6.3.15#6346)