Hi, when soring big tables using datagrid headers it crashes heidisql ui. I use to query just to sort it manually.
Sorting big tables crashes the program
Well I think it does not crash, it just takes long, and the HeidiSQL window doesn't respond during the query, right?
I have same problem. My version program 126.96.36.19969 Can you optimize sorting algorithm of big tables in future builds? Is it possible make program multi-threading in order to it use several cores of CPU?
The query execution done in a query tab is already running in a separate thread. All other things are running in HeidiSQL's main thread.
Especially running queries for the data grid would require big efforts, and the effect would be minimal. The user would be able to do some other stuff, but not much. You would not be able to execute another query, not even clicking a different table or database in the tree, which would fire internal queries. The reason is that the connection to the MySQL server only allows to run one query at a time.
Please login to leave a reply, or register at first.