Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-6752

Duplicate expression nodes in extract nodes during WHERE compilation phase leads to poor performance.

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Critical
    • Resolution: Resolved
    • 4.15.0, 5.1.0, 4.16.1, 5.2.0
    • 5.2.0, 5.1.3
    • None
    • None

    Description

      SQL queries using the OR operator were taking a long time during the WHERE clause compilation phase when a large number of OR clauses (~50k) are used.

      The key observation was that during the AND/OR processing, when there are a large number of OR expression nodes the same set of extracted nodes was getting added.

      Thus bloating the set size and slowing down the processing.

      code

      Attachments

        1. test-case.txt
          2 kB
          Jacob Isaac

        Activity

          People

            jisaac Jacob Isaac
            jisaac Jacob Isaac
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: