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.

      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

        No work has yet been logged on this issue.

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development