[MCOL-4408] Updates are slower than in 1.2.5 Created: 2020-11-20  Updated: 2021-01-14

Status: Open
Project: MariaDB ColumnStore
Component/s: DMLProc
Affects Version/s: 5.4.3
Fix Version/s: Icebox

Type: Bug Priority: Major
Reporter: David Hall (Inactive) Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Relates
relates to MCOL-3277 slow update statements Closed
relates to MCOL-3439 Very slow delete/update in mariadb (c... Closed

 Description   

Updates appear to significantly slower in 5.4 than they were in 1.2.5. A study needs to be done to verify this and to determine the amount of slowdown, and in what version it first appeared.

This also seems to affect DELETE statements.

This seems to be generic, so any UPDATE...WHERE statement can be used to test. We should probably test for WHERE = a single value, and multi-value.


Generated at Thu Feb 08 02:50:07 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.