Hi, *connection* is the right one, not "connections". Best Regards,
Luca Garulli CEO at Orient Technologies LTD the Company behind OrientDB <http://orientdb.com> On 5 June 2015 at 15:21, James Wang <[email protected]> wrote: > Found how to kill a slow query: > http://orientdb.com/docs/2.0/orientdb.wiki/OrientDB-REST.html > > There is a typo in the above page: connection should be connections > i.e. to kill query id 36, browser > http://yourserver:2480/connections/kill/36 > > Still to find how to timeout automatically > > Thanks > > On Friday, 5 June 2015 12:39:50 UTC+1, James Wang wrote: >> >> 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. > -- --- 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.
