Hi, I am using the plocal storage and the version I am using is orientdb-community-1.7-rc2.
Thank you, Hoan On Thursday, April 10, 2014 6:01:20 PM UTC+7, Andrey Lomakin wrote: > > Hi, > At first which storage and version do you use ? > > > On Thu, Apr 10, 2014 at 1:43 PM, Hoan Nguyen > <[email protected]<javascript:> > > wrote: > >> Hi, >> >> I have the following query: >> >> select expand(out()) from #12:1231 >> 1 item(s) found. Query executed in 8.638 sec(s). >> and the explain command result is: >> Profiled command >> { >> expandElapsed:0, >> current: #12:1231, >> fetchingFromTargetElapsed:0, >> documentReads:1, >> recordReads:1, >> elapsed:0.464178, >> resultType:collection, >> resultSize:1 >> } >> in 0.001000 sec(s): >> >> { >> expandElapsed:0, >> current: #12:1231, >> fetchingFromTargetElapsed:0, >> documentReads:1, >> recordReads:1, >> elapsed:0.464178, >> resultType:collection, >> resultSize:1 >> } >> >> With a database of ~4M vertices, 2 classes A and B (3M9 and 100k >> correspondingly) and 3M9 . A has edges to B and one vertex in B can have >> multiple edges coming from A. >> I don't know why this query takes too much time. >> Even a much more simpler query like: >> select from #12:5487 >> 1 item(s) found. Query executed in 1.655 sec(s). >> >> I guess OrientDB doesn't have an index on RID, and each time I query >> using RID, it does a full system scan. >> Is there anyway to speed up this process? (I tried to index the RID but I >> cannot do that) >> >> Thank you in advance, >> Hoan >> >> >> >> -- >> >> --- >> 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] <javascript:>. >> For more options, visit https://groups.google.com/d/optout. >> > > > > -- > Best regards, > Andrey Lomakin. > > Orient Technologies > the Company behind OrientDB > > -- --- 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.
