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







All Articles