Re: [orientdb] Help optimize a query and/or graph design

2015-06-11 Thread Khaled B
Hi Enrico, I'm using Orientdb 2.0.5. On Wednesday, June 10, 2015 at 6:53:17 PM UTC+3, Enrico Risa wrote: > > Hi Khaled > > which version of OrientDB are you using? > > > > 2015-06-10 14:29 GMT+02:00 Khaled Bakhit >: > >> Hello, >> >> I need help optimizing a query or maybe even update the g

Re: [orientdb] Help optimize a query and/or graph design

2015-06-10 Thread Enrico Risa
Hi Khaled which version of OrientDB are you using? 2015-06-10 14:29 GMT+02:00 Khaled Bakhit : > Hello, > > I need help optimizing a query or maybe even update the graph structure. > > I have the following relation : > > User ( userid, country ) - - - - - Likes - - - - > Movie ( movieid ) > > m

[orientdb] Help optimize a query and/or graph design

2015-06-10 Thread Khaled Bakhit
Hello, I need help optimizing a query or maybe even update the graph structure. I have the following relation : User ( userid, country ) - - - - - Likes - - - - > Movie ( movieid ) movieid and userid are unique indexes, while country is a non-unique index. I'm using the following query to g