Avoid sorting by clicking column header #221

Closed
aamine opened this Issue May 20, 2016 · 6 comments

Comments

Projects
None yet
2 participants
@aamine

aamine commented May 20, 2016

For very large tables (50,000,000,000 rows for my case), sorting does not work completely. Once we start sorting the table, all other queries stop working...

Sorting by clicking column header is handy nice feature for smaller tables, but it is too dangerous for large tables. Do you have any idea to disable or avoid sorting?

My idea: I always disable "Always sort tables" and "Retrieve exact row counts" options because it does not work for many (large) tables. What do you think that the option disables all kind of sorting action (from UI) ?

@jakob

This comment has been minimized.

Show comment
Hide comment
@jakob

jakob May 20, 2016

Owner

Did you try pressing cmd-. to cancel the query? Does that not work?

Owner

jakob commented May 20, 2016

Did you try pressing cmd-. to cancel the query? Does that not work?

@aamine

This comment has been minimized.

Show comment
Hide comment
@aamine

aamine May 23, 2016

Yes, cmd-. magically works, thanks!

But I still think the sorting feature is not error proof, especially for non-engineer people. In my company, a dozen people are analyzing large log tables using Postico, and they accidentally click the column header every day.

Even worse, Postico memoizes sorting settings for each table, so their Postico processes dispatches sorting query again and again, until they explicitly cancel it and click column header again (to cancel sorting operation). That is too complicated opeartion, isn't it?

aamine commented May 23, 2016

Yes, cmd-. magically works, thanks!

But I still think the sorting feature is not error proof, especially for non-engineer people. In my company, a dozen people are analyzing large log tables using Postico, and they accidentally click the column header every day.

Even worse, Postico memoizes sorting settings for each table, so their Postico processes dispatches sorting query again and again, until they explicitly cancel it and click column header again (to cancel sorting operation). That is too complicated opeartion, isn't it?

@jakob

This comment has been minimized.

Show comment
Hide comment
@jakob

jakob May 23, 2016

Owner

Would it help if Postico automatically cancelled the query when people click the column header (to change sort order) while a previous query is still running?

Owner

jakob commented May 23, 2016

Would it help if Postico automatically cancelled the query when people click the column header (to change sort order) while a previous query is still running?

@aamine

This comment has been minimized.

Show comment
Hide comment
@aamine

aamine May 24, 2016

Yes, I think it is reasonable!

aamine commented May 24, 2016

Yes, I think it is reasonable!

@jakob

This comment has been minimized.

Show comment
Hide comment
@jakob

jakob May 25, 2016

Owner

Postico now automatically cancels the query if it is still running when clicking the table header. This change will be in the next update.

You can download a prerelease version here:
https://eggerapps-downloads.s3-eu-west-1.amazonaws.com/postico-1427.zip

Owner

jakob commented May 25, 2016

Postico now automatically cancels the query if it is still running when clicking the table header. This change will be in the next update.

You can download a prerelease version here:
https://eggerapps-downloads.s3-eu-west-1.amazonaws.com/postico-1427.zip

@jakob jakob added the done label May 25, 2016

@aamine

This comment has been minimized.

Show comment
Hide comment
@aamine

aamine May 27, 2016

Amazing, that looks nice!!! Thanks

aamine commented May 27, 2016

Amazing, that looks nice!!! Thanks

@aamine aamine closed this May 27, 2016

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment