Hi,
you should take before all users Americans who likes as the id of the movie
you want, and then filter by number.
SELECT userid FROM ( select from (SELECT expand(in("Likes")) FROM Movie
where movieid = 112) WHERE country="us" ) limit 500
regards
Savio L.
Il giorno mercoledì 10 giugno 2015 17:44:50 UTC+2, Khaled Bakhit ha scritto:
>
> 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.
