Data tab / order side effect

BubikolRamios's profile image BubikolRamios posted 6 years ago in General Permalink

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.

BubikolRamios's profile image BubikolRamios posted 6 years ago Permalink

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.

BubikolRamios's profile image BubikolRamios posted 6 years ago Permalink

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

[expired user #1502]'s profile image [expired user #1502] posted 6 years ago Permalink

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

BubikolRamios's profile image BubikolRamios posted 6 years ago Permalink

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.

[expired user #1502]'s profile image [expired user #1502] posted 6 years ago Permalink

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.

BubikolRamios's profile image BubikolRamios posted 6 years ago Permalink
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.

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