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

Sorting cannot utilize indexes #3227

Open

zhangliang-zl opened this issue Jan 24, 2024 · 0 comments

zhangliang-zl commented Jan 24, 2024

My statement is as follows:

GRAPH.QUERY "asset" "CREATE INDEX :Device(updatedTime)"

GRAPH.QUERY "asset" "MATCH (dev1 :Device) RETURN dev1 ORDER BY dev1.updatedTime DESC SKIP 0 LIMIT 10"

My data volume is around 500w, and this query statement requires 3000ms. How should I accelerate it?

It is very fast without order by. Can I specify the default sorting of the data to speed up when writing data?

gkorland mentioned this issue

Sorting cannot utilize indexes FalkorDB/FalkorDB#555

Open

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