User: UserId (string, index)
Conversation: ConversationId (string, index), lastUpdateTime (int)
User —ParticipatesIn----> Conversation
Conversation —ParticipatedBy-----> User
- Get all participants of a conversation, paginated, ordered by userId.
- Get all conversations an user is part of, paginated, ordered by lastUpdateTime
I will update the lastUpdateTime field of an conversation extremely frequently.
Do I have to (or is it suggested to) create an index on lastUpdateTime, for faster query (as I’m ordering based on it)?
And most importantly, is Dgraph suitable for such update-heavy workload?
Want honest opinion here.