I’m implementing Couchbase Server 4.0 to manage the data storage of an instant messaging app I’m developing. I’ve arrived to the conclusion that the new indexing system of N1QL could help. In this particular case, I want to index user’s messages to make different queries on them (last read message, last synchronization date, etc.). Taking that into account, is it a good strategy to create an index for each conversation in my system? If so, performance would be affected by that? And, is there a limitation in the amount of indexes that can be created or that are recommended to create?
Thanks in advance.
Waiting for an answer or ideas to solve the problem.