[MXS-4728] Laggy issues on result data table Created: 2023-08-24  Updated: 2024-01-25  Resolved: 2023-10-23

Status: Closed
Project: MariaDB MaxScale
Component/s: maxgui
Affects Version/s: 6.4.9, 22.08.7, 23.02.3
Fix Version/s: 23.08.4

Type: Bug Priority: Major
Reporter: Duong Thien Ly Assignee: Duong Thien Ly
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Blocks
is blocked by MXS-4789 GUI workspace caching doesn't work ac... Closed
Problem/Incident
causes MXS-4855 While writing query GUI response very... Closed
Sprint: MXS-SPRINT-191, MXS-SPRINT-192

 Description   

The result data table supports only vertical virtual scroll, if the resultset has a large number of columns, the memory consumption would increase significantly and cause laggy issues.
The virtual scroll should automatically work in both directions, vertical and horizontal.
At the moment, the customized virtual scroll table component is built on top of vuetify v-virtual-scroll which supports only vertical direction.

https://nhn.github.io/tui.grid/latest/ is a good candidate to replace the customized component.
Example: https://codesandbox.io/s/tui-grid-vrtmjj
However, building a virtual scroll component from scratch seems to be a better idea instead of relying on 3rd party library.



 Comments   
Comment by Duong Thien Ly [ 2023-10-23 ]

Adding virtualization support for both axes is nice but not trivial.
Hence, the current result data table has been optimized to handle many columns.
Only the first 50 columns will be rendered by default to prevent laggy scrolling.

Generated at Thu Feb 08 04:30:43 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.