Details

      Description

      This was raised by the Phoenix team. During a profiling session we noticed that catching the joinedHeap up to the current rows via seek causes a performance regression, which makes the joinedHeap only efficient when either a high or low percentage is matched by the filter.
      (High is fine, because the joinedHeap will not get behind as often and does not need to be caught up, low is fine, because the seek isn't happening frequently).

      In our tests we found that the solution is quite simple: Replace seek with reseek. Patch coming soon.

        Attachments

        1. 8316-0.94.txt
          0.9 kB
          Lars Hofhansl
        2. 8316-trunk.txt
          1 kB
          Ted Yu
        3. 8316-trunk.txt
          1 kB
          Ted Yu
        4. FDencode.png
          90 kB
          Lars Hofhansl
        5. noencode.png
          90 kB
          Lars Hofhansl

          Activity

            People

            • Assignee:
              larsh Lars Hofhansl
              Reporter:
              larsh Lars Hofhansl
            • Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: