Hey,
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 Table: tablename
?
Some of these could be performed on demand (the user clicks the Table
tab).
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 Table
tab, I don't really go to CREATE code
tab that much.
Thanks