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 get the first 500 users who liked movie x
from country y.
SELECT userid FROM (SELECT expand(in("Likes")) FROM Movie WHERE movieid=112
limit 500) WHERE country="US"
The problem is this does not get guarantee getting 500 users from US (
because the query first gets first 500 users and then filters by country ).
Removing the limit 500 is not an option as well since some movies can have
millions of likes.
Any suggestions on improving this issue and have the country index get used
from within the Movie subquery?
Thank your for your help and this great product :)
--
---
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.
