mongodb / mongo-perf

performance tools for mongodb
351 stars 140 forks source link

PERF-3800 Add CWI.query tests #125

Closed aligusnet closed 1 year ago

aligusnet commented 1 year ago

Command to run:

python benchrun.py -f testcases/compound_wildcard_index_query.js --readCmd --trialTime 1 -t 4 8

Some of the test results (too many tests to list all of them):

[CWI.query] Regular. 3 fields. Point Query. Collection size 1000 docs.
4       11042.0704081908
8       17324.696637905443
[CWI.query] Regular. 3 fields. Point Query. With sort. Collection size 1000 docs.
4       7792.836108539934
8       9717.905928672071
[CWI.query] Regular. 3 fields. Point Query. Covered. Collection size 1000 docs.
4       11862.041666583367
8       17643.578329172222
[CWI.query] Regular. 3 fields. Point Query. Collection size 100000 docs.
4       11463.941764615327
8       17339.561328190208
[CWI.query] Regular. 3 fields. Point Query. With sort. Collection size 100000 docs.
4       7730.47767056272
8       9635.97537395239
[CWI.query] Regular. 3 fields. Point Query. Covered. Collection size 100000 docs.
4       11303.478608556577
8       17496.81149222164
[CWI.query] Regular. 3 fields. Range Query. Collection size 1000 docs.
4       10357.67049373362
8       16595.94285862767
[CWI.query] Regular. 3 fields. Range Query. With sort. Collection size 1000 docs.
4       7647.426838750426
8       9597.341321625343
[CWI.query] Regular. 3 fields. Range Query. Covered. Collection size 1000 docs.
4       10264.479283605724
8       17078.957572947107
[CWI.query] Regular. 3 fields. Range Query. Collection size 100000 docs.
4       10552.705049045038
8       16519.072037705337
[CWI.query] Regular. 3 fields. Range Query. With sort. Collection size 100000 docs.
4       7246.876527255991
8       9507.650586096948
[CWI.query] Regular. 3 fields. Range Query. Covered. Collection size 100000 docs.
4       10921.855805915413
8       16966.651375092326
[CWI.query] Regular. 3 fields. Point and Range Query. Collection size 1000 docs.
4       10393.268816494878
8       16655.773355159934
[CWI.query] Regular. 3 fields. Point and Range Query. With sort. Collection size 1000 docs.
4       7440.6546576799155
8       9588.427945416797
[CWI.query] Regular. 3 fields. Point and Range Query. Covered. Collection size 1000 docs.
4       10720.090198689
8       17050.139061417878
[CWI.query] Regular. 3 fields. Point and Range Query. Collection size 100000 docs.
4       10655.428821035775
8       16525.852754591986
[CWI.query] Regular. 3 fields. Point and Range Query. With sort. Collection size 100000 docs.
4       7544.428076585588
8       9481.812124051794
[CWI.query] Regular. 3 fields. Point and Range Query. Covered. Collection size 100000 docs.
4       10894.805499882545
8       16862.08509396475
[CWI.query] Regular. 3 fields. Prefix query. Collection size 1000 docs.
4       11169.627409216168
8       17557.607463632383
[CWI.query] Regular. 3 fields. Prefix query. With sort. Collection size 1000 docs.
4       8578.624901300336
8       10680.384885576585
[CWI.query] Regular. 3 fields. Prefix query. Covered. Collection size 1000 docs.
4       12029.152251642588
8       17889.379124492967