Hi All, How to kill a slow query from console.sh please?
Also, is there a setting which automatically timeout a long slow query? Thanks a lot in advance On Thursday, 4 June 2015 09:06:28 UTC+1, James Wang wrote: > > Hi All, > > I am new to OrientDB and like it. > > I have two classes: users and userFriends > users class, with properties like name, email (unique) et al, has 9m fake > records and userFriends class > (with properties like name, group et al) has 1m fake records; > > For statistic purpose, I need to find out, for example, those who are not > John (whose @RID #12:0 in userFirends class) friends. The query I run: > select * from users where email not in (select email from (traverse in() > from #12:0)) limit 10; > > "traverse in() from #12:0" has 20000 edges (i.e. John has 20000 friends - > too many - is it not? - just for testing ideas) > > What have I done wrong please? > > BTW, if users only has 1m records and John only has only 2000 friend, the > query "select * from users where email not in (select email from (traverse > in() from #12:0)) limit 10;" only took 0.2 seconds > > Please help > > Thanks a lot in advance > James > -- --- 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.
