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

✨ [CLICKBENCH] Very Slow Query #2230

Open

joocer opened this issue Jan 10, 2025 · 1 comment

Contributor

joocer commented Jan 10, 2025 •

edited

Loading

SELECT * FROM hits WHERE URL LIKE '%google%' ORDER BY EventTime LIMIT 10;

This query performs a lot slower than other engines.

I'm not sure how they would achieve the performance they do.

Contributor Author

joocer commented Jan 17, 2025

Some improvement but by rewriting the LIKE condition, this query was running in 75 seconds to 52 seconds.

More improvement is needed, but this is a significant reduction in execution.

joocer added a commit that referenced this issue


          #2230

7f67737

joocer added a commit that referenced this issue


          #2230

4b4202a

joocer added a commit that referenced this issue


          Merge pull request #2294 from mabel-dev/#2230/1

411cee7

#2230/1

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