Release 205
I have 2 Vertex:
- ClassUser
- ClassImage
And 2 Edge:
- Uploaded from ClassUser to ClassImage
- Seen from ClassUser to ClassImage
Now i want return all image what not uploaded by this user and dont seen by
this user.
Mu query work ok, but i think it will not work then many seen images will
be in database (1000+)
Becouse i do it with "not in" operator. Its looks ugly:
select * from ClassImage where
@rid not in (select @rid from (select expand(out('Uploaded')) from
#14:24))
and
@rid not in (select @rid from (select expand(out('Seen')) from #14:24))
//any limits on in members?
limit 10
Is this query correct? How rewrite this without not in?
Thank you!
--
---
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.
