Convert CH arrays to string in work items table
What does this MR do and why?
Based on performance measurements, filtering array columns is slower than de-normalizing an array into a String (!196808 (comment 2625174627)).
This MR converts the assignee_ids[] and label_ids[] to String columns where the id values are casted to string: /1/2/3/.
What does the MR do:
- Drop the MV.
- Drop the columns and re-add them as String.
- Add the updated MV.
The tables and MVs are not in use yet, so we can safely remove and add the columns.
MR acceptance checklist
Evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.
Edited by Adam Hegyi