Ads were blocked by your webbrowser.

This is not a 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 11 months 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's profile image BubikolRamios posted 11 months 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's profile image BubikolRamios posted 11 months ago

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



Ads were blocked by your webbrowser.

This is not a 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 11 months 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's profile image BubikolRamios posted 11 months 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's profile image Misha v.3 posted 11 months 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's profile image BubikolRamios posted 11 months 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.

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