I'm still evaluating OrientDB so I might be totally off but I would index the edge class (SOME_LABEL).
Also take a look at http://orientdb.com/docs/last/RidBag.html On Thursday, April 30, 2015 at 4:27:40 AM UTC-7, [email protected] wrote: > > Hi, > > I have very dense graph that contains vertexes with a lot of edges and I > need to fetch the X last edges added to the Vertex. > > Orient SQL allows me to do it like this: > > - select out('SOME_LABEL')[80000] from #1:0 > - please note that this is single direction (out) and a single link > type / label ('SOME_LABEL') > > I have several questions regarding this: > > - Are the edges in a consistent order? > - Assuming append-only operations and no deletions > > - Can anything be done to speed this up? > - I ask because this query is very slow (0.7 sec.) > - Asking for a list "select > > out('ACTOR')[79220,79221,79222,79223,79224,79225,79226,79227,79228,79229,79230] > > from #140:0" takes almost n*req_time longer > > - What happens underneath (is the whole list iterated from top to get > to this) > > - Can this be achieved using the Java API? > > Assistance is highly appreciated. > > Best regards, > -Stefan > -- --- You received this message because you are subscribed to the Google Groups "OrientDB" 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.
