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

[FEATURE] Improve Performance of ORDER BY RANDOM() #58

Closed
joocer opened this issue Apr 17, 2022 · 0 comments
Closed

[FEATURE] Improve Performance of ORDER BY RANDOM() #58

joocer opened this issue Apr 17, 2022 · 0 comments

Comments

@joocer
Copy link
Contributor

joocer commented Apr 17, 2022

This currently works by assigning a random number to each row and then sorting by the new column, what would probably be faster is creating a 0..n list, where n is the number of rows, shuffling this list and then using .take() to get the shuffled rows (in chunks)
@joocer joocer added the Bug 🪲 Something isn't working label Apr 17, 2022
@joocer joocer added this to the beta release milestone Apr 17, 2022
@joocer joocer self-assigned this Apr 17, 2022
@joocer joocer modified the milestones: beta release, 0.2 Apr 17, 2022
@joocer joocer removed their assignment Apr 20, 2022
@joocer joocer removed the Bug 🪲 Something isn't working label Apr 20, 2022
@joocer joocer removed this from the 0.2 milestone Jul 2, 2022
@joocer joocer closed this as completed Aug 26, 2022
joocer added a commit that referenced this issue Aug 26, 2022
@joocer
FEATURE/#58
72c83e7
joocer added a commit that referenced this issue Aug 26, 2022
@joocer
FEATURE/#58
dc3eb51
joocer added a commit that referenced this issue Aug 26, 2022
@joocer
Merge pull request #418 from mabel-dev/FEATURE/#58-2
f411a50 
Feature/#58 2
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@joocer