Data tab / order side effect

BubikolRamios posted 1 month ago in General

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 posted 1 month ago

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 posted 1 month ago

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

Misha v.3 posted 1 month ago

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 posted 4 weeks ago

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.

Misha v.3 posted 4 weeks ago

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 posted 3 weeks ago
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.

mattsmith11 posted 15 hours ago

Very informative

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