Hello guys.I want to ask a question.If i disable the default compression by wired-tiger on my collection do i get faster or slower execution times on queries (aggregates pipelines)?Does compression have any thing to do with queries execution time in general?
Hi @harris ,
The compression is done for disk space saving mainly .
When query executes it decompress the data anyway.
Compressing data allows also the storage filesystem cache to hold more data so there is a bigger chance uncompressed data will have larger scanning times vs the savings in cpu decompress overhead.
However, you should test the impact on your hw and data.