I've been working with Heidi on a db in Aws Aurora. (everything works great) The issue I've been having is that sometimes I click on the wrong table and Heidi starts loading all the table data. These are the queries I see Heidi perform:
SELECT * FROM `information_schema`.`COLUMNS` WHERE TABLE_SCHEMA='database' AND TABLE_NAME='table1' ORDER BY ORDINAL_POSITION; SHOW INDEXES FROM `table1` FROM `database`; SELECT * FROM information_schema.REFERENTIAL_CONSTRAINTS WHERE CONSTRAINT_SCHEMA='database' AND TABLE_NAME='table1' AND REFERENCED_TABLE_NAME IS NOT NULL; SELECT * FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA='database' AND TABLE_NAME='table1' AND REFERENCED_TABLE_NAME IS NOT NULL; SHOW CREATE TABLE `database`.`table1`;
Can we skip some of these queries if the user is not on the tab
Some of these could be performed on demand (the user clicks the
Locally I don't have any issues as this is super fast but on aws it takes a few seconds to perform all this, and even if I do go to the
Tabletab, I don't really go to
CREATE code tab that much.