I was trying to improve the performance using indexes in the collection but create an index in a collection( 20GB size - data) brings down the primary node, it uses all the RAM available (2GB RAM)
So, in this case, how can improve performance? using the same RAM
Maybe … split the collections in some smaller collections
Which is the size recommending for a collection??
2GB RAM is too small for any database.
1 Like
Hi @Valeria_Haro,
Great question! We have a great community forum where you can have an in-depth conversation about specific use cases and interesting problems that you get to solve using MongoDB. I would highly recommend posting your question there for a more involved discussion.
Thanks,
Sonali