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

Log workAgile BoardRank to TopRank to BottomAttach filesAttach ScreenshotBulk Copy AttachmentsBulk Move AttachmentsAdd voteVotersWatch issueWatchersCreate sub-taskConvert to sub-taskLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    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
          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

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

            Dates

              Created:
              Updated:

              Slack

                Issue deployment