Hey Cyprien, it's going well, thanks!
In general, yes, using LIMIT with a high offset can take more time than to return the first few documents if there's a huge dataset to process to answer the query. But it depends on the exact query. Reading all content of the documents can be avoided in several cases, but it may still be necessary to walk through an index data structure up to the documents that need to be processed and returned. Can you post the exact query (or queries) you need so that we can better understand the goal and check what the options are to optimize it? Maybe a secondary index can be utilized to select the relevant documents? Or maybe you know the document keys and can do point lookups for them? Regarding range FILTERs: It is currently not possible to do that using an index on the _key attribute, but this may change: https://github.com/arangodb/arangodb/issues/7720 Best, Simran -- You received this message because you are subscribed to the Google Groups "ArangoDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
