Arangodb AQL Limit> 1000
I am seeing a problem when used LIMIT > 1000
in AQL:
- the request is fast before
LIMIT 1000
, which lasts less than a second. - starting from
LIMIT 1001
, the request becomes very slow ... I abort it after 20 seconds.
Here are some examples:
FOR e IN subcategoryOf
LIMIT 1000
RETURN { "id": e._id, "text": e.text }
--> Fast, below a second
FOR e IN subcategoryOf
LIMIT 1, 1000
RETURN { "id": e._id, "text": e.text }
--> Fast, below a second
FOR e IN subcategoryOf
LIMIT 1, 1001
RETURN { "id": e._id, "text": e.text }
--> not answering after 20 seconds, manually aborted then.
Does anyone observe the same or have a clue for me?
I am using ArangoDB 2.3.0 on Windows and aardvark AQL editor.
+3
source to share
1 answer
Thanks, it was a bug in the web interface. I have fixed this in this commit: https://github.com/triAGENS/ArangoDB/commit/7656efd82fcbb31160d2ca4842f72190491101b8
+7
source to share