Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

BUG: Opening table defaults sorts on first column #1417

Open
jancoow opened this issue Nov 3, 2022 · 2 comments · May be fixed by #2235
Open

BUG: Opening table defaults sorts on first column #1417

jancoow opened this issue Nov 3, 2022 · 2 comments · May be fixed by #2235
Labels
accepted 👍 bug Something isn't working good first issue Good for newcomers

Comments

@jancoow
Copy link

jancoow commented Nov 3, 2022

When viewing data of a table, it default sorts on the first column. This will put a huge load when opening a large table, and in my case the query will easily take 10 minutes +.

It should not automatically select a column to sort. Also, when closing the tab the query won't be canceled so the load will continue on the database. There is no way to see running queries in the GUI.

Using postgresql.
@rathboma rathboma added bug Something isn't working accepted 👍 labels Nov 16, 2022
@rathboma
Copy link
Collaborator

I agree with this. You are totally right. We should be able to fix this fairly easily, although some db engines don't support limit/offset without a sort order, so will require some workarounds

@rathboma rathboma mentioned this issue Mar 16, 2023
Open
@michi-zuri
Copy link
Contributor

Mabye using limit and offset is not the best pagination solution: https://use-the-index-luke.com/no-offset
Which db engines are you referring to @rathboma ?

@rathboma rathboma added the good first issue Good for newcomers label May 3, 2023
@michi-zuri michi-zuri linked a pull request Jun 5, 2024 that will close this issue
Open
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
accepted 👍 bug Something isn't working good first issue Good for newcomers
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

remove automatic ordering by first column feature/bug michi-zuri/beekeeper-studio
4 participants
@rathboma @jancoow @michi-zuri @ksdevinney