Sorting big tables crashes the program

[expired user #10445]'s profile image [expired user #10445] posted 7 years ago in General Permalink

Hi, when soring big tables using datagrid headers it crashes heidisql ui. I use to query just to sort it manually.

ansgar's profile image ansgar posted 7 years ago Permalink

Well I think it does not crash, it just takes long, and the HeidiSQL window doesn't respond during the query, right?

[expired user #9413]'s profile image [expired user #9413] posted 7 years ago Permalink

I have same problem. My version program 9.4.0.5169 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?

ansgar's profile image ansgar posted 7 years ago Permalink

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.