Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Lazy load table info

Acs's profile image Acs posted 4 weeks ago in General Permalink

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 Tabletab, I don't really go to CREATE code tab that much.

Thanks

Please login to leave a reply, or register at first.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.