mongodb / mongo-perf

performance tools for mongodb
351 stars 140 forks source link

PERF-3799 Add CWI.update tests #126

Closed RuoxinXu closed 1 year ago

RuoxinXu commented 1 year ago

Command to run: python benchrun.py -f testcases/compound_wildcard_index_update.js -t 1 2

Results:

[CWI.update] Compound Regular Index with 2 fields. Collection size 1000 docs.
1   4385.137768761428
2   8622.722301184514
[CWI.update] Compound Regular Index with 2 fields. Collection size 100000 docs.
1   4466.134711598132
2   8503.479587049273
[CWI.update] Compound Wildcard Index with 2 fields. Collection size 1000 docs.
1   6008.4125375288295
2   11465.00381980137
[CWI.update] Compound Wildcard Index with 2 fields. Collection size 100000 docs.
1   5878.209546010708
2   11349.564424392234
[CWI.update] Compound Regular Index with 2 fields, one of which is multikey. Collection size 1000 docs.
1   5901.702554191269
2   11078.197346064375
[CWI.update] Compound Regular Index with 2 fields, one of which is multikey. Collection size 100000 docs.
1   5803.598034788389
2   11267.951535528886
[CWI.update] Compound Wildcard index with 2 fields, one of which is multikey. Collection size 1000 docs.
1   5822.297240543492
2   11257.04390203124
[CWI.update] Compound Wildcard index with 2 fields, one of which is multikey. Collection size 100000 docs.
1   5773.990981526468
2   11031.145516804707
[CWI.update] Compound Regular Index with 2 fields, prefixed wildcard field. Nested object update. Collection size 1000 docs.
1   4433.296762501445
2   8499.548413366963
[CWI.update] Compound Regular Index with 2 fields, prefixed wildcard field. Nested object update. Collection size 100000 docs.
1   4343.236694300294
2   8273.252310697031
[CWI.update] Compound Wildcard Index with prefixed wildcard field. Nested object update. Collection size 1000 docs.
1   3812.193379118852
2   7618.957717144594
[CWI.update] Compound Wildcard Index with prefixed wildcard field. Nested object update. Collection size 100000 docs.
1   3828.8828361852125
2   7231.250424967703