Ok, so no index has been used. Could you please drop and recreate it? If you are using 'primaryid' to just lookups and never ranges (ex: SELECT FROM cluster:demo15q4 WHERE primaryid > 117596311) I suggest you to use the HASH_INDEX because it's faster.
Best Regards, Luca Garulli Founder & CEO OrientDB LTD <http://orientdb.com/> On 19 June 2016 at 16:13, Fabio Rinnone <[email protected]> wrote: > Sorry, I did not understand, the output of EXPLAIN is the following: > > Profiled command > > '{documentReads:314858,current:#23:314857,recordReads:314858,fetchingFromTargetElapsed:6029,evaluated:314858,user:#5:0,tips:[1],elapsed:6030.6943,resultType:collection,resultSize:1}' > in 6.037000 sec(s): > > {"@type":"d","@version":0,"documentReads":314858,"current":"#23:314857","recordReads":314858,"fetchingFromTargetElapsed":6029,"evaluated":314858,"user":"#5:0","tips":["Query > 'SELECT FROM cluster:demo15q4 WHERE primaryid = 117596311' fetched more > than 50000 records: to speed up the execution, create an index or change > the query to use an existent > > index"],"elapsed":6030.6943,"resultType":"collection","resultSize":1,"@fieldTypes":"documentReads=l,current=x,recordReads=l,fetchingFromTargetElapsed=l,evaluated=l,user=x,elapsed=f"} > > The tip is the same of the Java application output. > > Il 19/06/2016 16:03, Luca Garulli ha scritto: > > Hi Fabio, > > > > I definitely suggest to move to v2.2. However, could you please try the > > EXPLAIN? > > > > Best Regards, > > > > Luca Garulli > > Founder & CEO > > OrientDB LTD <http://orientdb.com/> > > -- > Fabio Rinnone > Skype: fabiorinnone > Web: http://www.fabiorinnone.eu > > -- > > --- > 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. > -- --- 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.
