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. noencode.png
          90 kB
          Lars Hofhansl
        2. FDencode.png
          90 kB
          Lars Hofhansl
        3. 8316-trunk.txt
          1 kB
          Ted Yu
        4. 8316-trunk.txt
          1 kB
          Ted Yu
        5. 8316-0.94.txt
          0.9 kB
          Lars Hofhansl

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: