Ads were blocked by your webbrowser.

This is not a problem, but keep in mind that developing HeidiSQL, user support and hosting takes time and money.

You may want to send a donation instead.

Only load whats filtered

Farbenzwerg's profile image Farbenzwerg posted 4 months ago in Feature discussion

Hello,

in HeidiQSL all tables of a database are loaded, even if a filter is active. Problems occur than when there are large amounts of tables and you want to refresh the database. The time it takes to refresh is around 2 minutes. Would it be possible to implement that HeidiSQL selects only the tables that are in the filter i choose?

Greetings Farbenzwerg

ansgar's profile image ansgar posted 4 months ago

HeidiSQL basically fires a SHOW TABLE STATUS to get the list of tables, plus one for functions, procedures, triggers and events. And this takes 2 minutes on your server? How many objects do you have in that database? Sounds more like a very slow server to me.

Farbenzwerg's profile image Farbenzwerg posted 4 months ago

In the database are around 20000 tables. Refreshing this takes around 1 to 2 minutes (2 min often if the tables are loaded the first time). I only think i could be helpful to just load/select the tables which i choose with the filter.



Ads were blocked by your webbrowser.

This is not a problem, but keep in mind that developing HeidiSQL, user support and hosting takes time and money.

You may want to send a donation instead.
ansgar's profile image ansgar posted 4 months ago

The filter is just a display feature.

But you could disable "Full table status" in the session manager, on the Advanced tab. That could speed up the queries.

To be honest, I would definitely spread these 20000 tables, or restructure the whole server to keep the data in less tables.

Farbenzwerg's profile image Farbenzwerg posted 4 months ago

I disabled "Full table status" and it now loads faster. Thanks for the Support.

Greetings Farbenzwerg

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