From a vertex I want to fetch the next neighbors, like:
SELECT expand(out(“Friend”)) FROM #10:1234
Now I would like to paginate/filter the results. How can I do this efficiently? My first thought was to do something like:
SELECT FROM (SELECT expand(out(“Friend”)) FROM #10:1234) WHERE age = 32 SKIP 10000 LIMIT 100
But my understanding is that this will be slow and RAM intensive because the traversal to the (80000) friend vertices is done anyway and THEN filtered/paginated is this correct? Or how is this executed internally?
Any ideas to paginate/filter on expanded/traverse objects in an efficient and less RAM-intensive way?