...
- Discuss with DEVOPS to increase RAM.
- Wait until mongo for forums is in house
- Get the list of most used queries
...
Notes:
- It would be suggested to have a usable index for every query that we have. Slow queries can reduce the overall performance.
- Obtaining a list of queries would be ideal for index creation. The current indexes have not been designed with index intersection in mind.
Improvements:
After applying the index on Nov 11, 11:05, we can see a significant improvement as expected.
...