Created
February 26, 2024 16:19
-
-
Save morkai/db75aade62b4b9afebbd3fdcc2680d6f to your computer and use it in GitHub Desktop.
MongoDB v7 compression method comparison
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# MongoDB v7 compression method comparison | |
Collection with 1_000_000 documents and 7 indexes. | |
## insertMany() 1000x1000 documents | |
source storageSize=1443.0 MB (100.000%) | |
none d=111.254s storageSize=1423.9 MB ( 98.677%) | |
snappy d=110.791s storageSize= 404.9 MB ( 28.065%) | |
zlib d=113.979s storageSize= 269.5 MB ( 18.680%) | |
zstd d=111.900s storageSize= 216.2 MB ( 14.987%) | |
## find({}).batchSize(10) 1_000_000 documents | |
none d=85.548s (100.00%) | |
snappy d=85.628s (100.09%) | |
zlib d=90.565s (105.86%) | |
zstd d=90.565s (100.70%) | |
## find({createdAt: {$gte, $lt}}).batchSize(10) 363_564 documents | |
none d=32.961s (100.00%) | |
snappy d=32.762s ( 99.39%) | |
zlib d=32.724s ( 99.28%) | |
zstd d=32.688s ( 99.17%) | |
## aggregate([$group]) 1_000_000 documents to 78 documents | |
none d=1.951s (100.00%) | |
snappy d=2.466s (126.39%) | |
zlib d=4.430s (227.06%) | |
zstd d=2.587s (132.59%) | |
## aggregate([$group]) 1_000_000 documents to 1 document | |
none d=1.128s | |
snappy d=1.565s | |
zlib d=3.040s | |
zstd d=1.608s |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment