Description
When exporting objects, Heidi calls the column query for all selected tables, one by one, causing slowness in large and remote databases.
HeidiSQL version and OS
12.2.0.7337 Windows 11
Database server version
MariaDB 11.8.8
Reproduction recipe
Select Tables node, Right click, Export
You will see a lot off
SELECT * FROM information_schema.COLUMNS WHERE TABLE_SCHEMA='xxxxx' AND TABLE_NAME='xxx' ORDER BY ORDINAL_POSITION;
I think could be one query and delimited columns in select statment.
Error/Backtrace
Description
When exporting objects, Heidi calls the column query for all selected tables, one by one, causing slowness in large and remote databases.
HeidiSQL version and OS
12.2.0.7337 Windows 11
Database server version
MariaDB 11.8.8
Reproduction recipe
Select Tables node, Right click, Export
You will see a lot off
SELECT * FROM
information_schema.COLUMNSWHERE TABLE_SCHEMA='xxxxx' AND TABLE_NAME='xxx' ORDER BY ORDINAL_POSITION;I think could be one query and delimited columns in select statment.
Error/Backtrace