Review cursor caching

XMLWordPrintableJSON

    • Type: Improvement
    • Resolution: Unresolved
    • Priority: Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • Storage Engines
    • StorEng - Defined Pipeline
    • None

      Review why/if we need the cursors to be cached.

      Why the "cursor open/close" operation can be slow? Can the slowness be eliminated, thus removing the need to cache cursors?

      What else is impacted by cursor opens/closes? Performance, data size, history store, checkpoints, eviction, etc.

      Connection with long running queries?

      Consider Server's "cursor yielding" technique.

            Assignee:
            [DO NOT USE] Backlog - Storage Engines Team
            Reporter:
            Yury Ershov
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated: