We are using Atlas which is saw that in Performance advisor to us like below.
“Reduce the size of documents”
Large documents can result in excess cache pressure, especially if a small portion of them are being updated or queried.
Can you please briefly explain How to reduce documents size in production server without any impact application. what steps are we following ? any MongoDB commands let me know
I do not think that it is possible without any impact application.
Some strategies to reduce document size are:
shorter field names, but it impacts the application because the field names are changed
split big documents into 2 or more parts so that fields seldom used are in secondary collections, but it impacts the application because you have to $lookup when you want to access the seldom used fields
The easiest way to reduce cache pressure that does not affect the application is to add more RAM.