Uploaded image for project: 'Apache Trafodion (Retired)'
  1. Apache Trafodion (Retired)
  2. TRAFODION-327

LP Bug: 1324591 - Performance regression with OpenCart queries

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Critical
    • Resolution: Fixed
    • None
    • 0.7 (pre-incubation)
    • sql-cmp
    • None

    Description

      When moving from the trafodion_beta 0.6.4 release to the Trafodion 0.7.0 (v40174) and RC4 (v40719) releases, the time to prepare SQL queries in OpenCart has significantly increased.

      Attached is an example query demonstrating a lengthy compilation.
      Update statistics had been previously run on every column against all OpenCart tables.
      We also ensured that seapilot was disabled.

      Attachments

        Activity

          People

            Unassigned Unassigned
            joaniec Joanie Cooper
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: