Indexes for big collections

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.