Document Compression: performance and best practice

[RJacobsRN]

Hello,

We are evaluating activating Document Compression on our databases.
However looking through the documentation I can't find any indication of expected performance impacts.

What kind of impact can be expected from turning on compression?
And is it recommended to limit compression only to specific collections, or should we turn it on on all collections for maximum benefits?

Thanks
Rob

[ayende]

In our tests - we observed that we usually saw higher performance in the load because we reduced the amount of disk usage.
You typically have spare CPU capacity but are limited by the disk (especially on the cloud).

I would say that you should default to having this on, and only disable if there is an issue.