-
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.