Wired tiger and query execution time

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.