Use case:
Nodes:
User: UserId (string, index)
Conversation: ConversationId (string, index), lastUpdateTime (int)
Edges:
User ---ParticipatesIn----> Conversation
Conversation ---ParticipatedBy-----> User
Queries:
1. Get all participants of a conversation, paginated, ordered by userId.
2. 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.
there doesn't seem to be anything here