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.

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

Query returns in 0.32 seconds locally. Times out on DoltHub #563

Open
timsehn opened this issue Dec 18, 2024 · 1 comment
Open

Query returns in 0.32 seconds locally. Times out on DoltHub #563

timsehn opened this issue Dec 18, 2024 · 1 comment
Assignees
Labels
bug Something isn't working

Comments

@timsehn
Copy link

timsehn commented Dec 18, 2024

This query:

SELECT * FROM `writings` WHERE phelps IS NULL ORDER BY RAND() LIMIT 10;

This returns in 0.32 seconds locally but times out on DoltHub, even with the new 60s query timeout.

https://www.dolthub.com/repositories/holywritings/bahaiwritings/query/main?active=Tables&q=SELECT+*%0AFROM+%60writings%60%0AWHERE+phelps+IS+NULL%0AORDER+BY+RAND()%0ALIMIT+10%3B%0A

@timsehn timsehn added the bug Something isn't working label Dec 18, 2024
@timsehn
Copy link
Author

timsehn commented Dec 18, 2024

$ time dolt sql -q "SELECT * FROM writings WHERE phelps IS NULL ORDER BY RAND() LIMIT 10;" > /dev/null
dolt sql -q  > /dev/null  0.33s user 0.13s system 59% cpu 0.769 total

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants