Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-2671

GeodeFilter change to transform multiple OR s to use IN SET OQL predicate to significantly improve query performance

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • None
    • geode-adapter
    • None

    Description

      In Geode when we are querying thousands of rows using an IN query, IN SET query predicate gives high query performance than multiple OR s.

      I am making the change in the GeodeFilter translateMatch function by first checking if IN SET is applicable then only use it, otherwise the multiple OR code is called.

      Attachments

        Activity

          People

            Unassigned Unassigned
            chadasa-gs Sandeep Chada
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated: