Skip to content

Laggy when loading 100,000+ rows in MariaDB #2138

Open
@JOHAN-dev-7

Description

@JOHAN-dev-7

Description

When I load a table with approximately 1,000,000 rows in HeidiSQL (connected to MariaDB 11.7.2), the UI becomes very laggy, and the screen flickers during scrolling or browsing the table.
While I understand 1 million rows is a heavy load, the responsiveness is unexpectedly poor compared to other tools.

system info :

Operating System: Windows 11 Pro 64-bit
CPU: Intel Core i5-12400
RAM: 32 GB DDR5
Storage: Samsung 990 Pro 1TB NVMe SSD
Display: 1920x1080 @ 180Hz
GPU: Integrated Intel UHD 730 Graphics
HeidiSQL Version: 12.10.0.7028
MariaDB Version: 11.7.2

HeidiSQL version

12.10.0.7028

Database server version

MariaDB 11.7.2

Reproduction recipe

Connect to MariaDB 11.7.2 using HeidiSQL.

Open a table containing ~1,000,000 rows.

Scroll or perform a query like SELECT * FROM table.

Notice the lag and flickering in the UI.

Error/Backtrace

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions