Hello, I have social app similar to facebook, user can create posts and there other users can likes them.
so I created following vertices - User [_id, name, photo] - Post [_id, title, description] and there are following edges - User - > UserPosts - > Post - User - > UserLikes -> Post *I have not added any indexes yet, Please suggest the fields that I should index ? Also, for better query performance do you suggest to add properties on edges like byUserId?* Now, I want to retrieve following data: - Select all posts by logged in user and for each post if that user had liked too and I am expecting results like: postId, title, total likes, hasloggedUserLikedThisPost (true/false) 1, title1, 30, true 2. title2, 14, false -- --- 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.
