Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Data tab / order side effect

BubikolRamios's profile image BubikolRamios posted 1 year 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 1 year 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 1 year ago Permalink

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

Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.
Misha v.3's profile image Misha v.3 posted 1 year 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 1 year 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.

Misha v.3's profile image Misha v.3 posted 1 year 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 1 year 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.