Details

    • Type: Improvement
    • Status: In Progress
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: v2.1.0
    • Fix Version/s: None
    • Component/s: Query Engine
    • Labels:
      None

      Description

      Too many fuzzy keys in one scan may downgrade the performance. Currently if the number of fuzzy keys exceeds a threshold, like 200, the scan will not use fuzzy key. However, this may also downgrade the performance.
      There are many cases in eBay that the total number of fuzzy keys is around 1000. To deal with these cases, it's better to split the large fuzzy key set, like 5*200. Then for each subset, assign a scan. This strategy will increase the number of scan to reduce the number of fuzzy keys in each scan to improve the total performance.

        Activity

        There are no comments yet on this issue.

          People

          • Assignee:
            yaho Zhong Yanghong
            Reporter:
            yaho Zhong Yanghong
            Request participants:
            None
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated: