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.

how to lock column head buttons

KBfriend's profile image KBfriend posted 2 months ago in General Permalink

I clicked a column head in the data tab by mistake, and it run a 'sort by' query.
The table had more than 80M rows, so it leaded to service degradation.
Is there a way to lock column head buttons?

ansgar's profile image ansgar posted 2 months ago Permalink

No, there is no way to block that. But it could make sense to make that configurable, as the sorting dialog still provides a way to do the same. Just without the risk of doing it accidentally:

Description

Code modification/commit 7bea342 from Ansgar Becker <anse@heidisql.com>, 2 months ago, revision 6586
Make clicks on grid column headers configurable, so the user may disable it, preventing him from accidental sortings on large tables. See https://www.heidisql.com/forum.php?t=40026
ansgar's profile image ansgar posted 2 months ago Permalink

Next build has such an option to disable header clicks:

Description

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.