Data tab / order side effect

One can drag drop column to change order of columns in display. Sorting brings all that back to original which is unwanted, order of columns shoud stay as putted by user.

BTW, order is done, as it loks like, in program, at some (relatively small !) data quantity it should be done on server, otherwise it hangs (without option to cancel) and could take ages to sort.

and could take ages to sort. It does take ages.

BTW, order is done, as it loks like, in program, at some (relatively small !) data quantity it should be done on serve

Not sure what are you talking about.

When I click on Field column on Data tab, I see query in log:

SELECT Id, Field ... FROM test.Table ORDER BY Field DESC LIMIT 2000;

P.S. MySQL in my case

Right.

The point is, there is a difference if you have show all / not show all(default).

If show all is on and there is millions of records there should be cancel ordering option.

One should not use 'show all' on tables with millions of records. Especially if "ORDER BY ColumnWithNoIndex" is used.

I believe it is possible to generate guid, store it, add it as comment into "SELECT /HEIDISQL:{guid}/ FROM TableName ..." and then find process ID if user decided to stop such query. Feel free tu submit such feature request.

BTW, order is done, as it loks like, in program, at some (relatively small !) data quantity it should be done on server
Not sure what are you talking about.

When I click on Field column on Data tab, I see query in log:

SELECT Id, Field ... FROM test.Table ORDER BY Field DESC LIMIT 2000;

Note than that in query tab resultset there is no SELECT .... Hence sort is done inside exe, no option to cancel.