-
Type: Improvement
-
Resolution: Unresolved
-
Priority: Major - P3
-
None
-
Affects Version/s: None
-
Component/s: None
-
Storage Engines
-
StorEng - Defined Pipeline
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.