Details
-
Task
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
Description
Currently SQL UPDATE in MCS has the slowest path comparing with both INSERT [1] and DELETE [2]. UPDATE is a crucial part of a mixed OLTP workload so for HTAP it needs to become faster. This task is to estimate current rates and highlight bottlenecks and limitations.
1. Using fast insert cache feature
2. Using fast delete feature