I have a large table with some large json data in them. I accidentally clicked the header and now Heidi SQL constantly wants to sort by that column and whole app freezes. Every time I access that table, without fail "sorting grid rows" as Heidi sql wants to sort for me. This is killing my usage of the app. I tried to reset my settings and it still does this. Where can I reset the table settings or prevent Heidisql from doing the sort?
prevent "sorting grid rows"
I added a special menu item for that purpose, in the context menu of the left tree view. Just be sure to not have the "Data" tab active but the "Table" tab when you click the table.

If you want to disable the storing of sorting and filtering permanently, disable it in Tools > Preferences > Data editors:

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