search

mongodb / mongo-perf

performance tools for mongodb
350 stars 139 forks source link

PERF-3797 Add CWI intersection performance tests #122

Closed aligusnet closed 1 year ago

aligusnet commented 1 year ago

Example results for python benchrun.py -f testcases/compound_wildcard_index_insert.js -t 1 2 run:

[CWI.insert] Compound Regular Index with 2 fields. Inserting batches of 1 doc.
1       6902.051443623284
2       13363.981237054299
[CWI.insert] Compound Regular Index with 2 fields. Inserting batches of 100 docs.
1       2834.467346848199
2       5171.561846858444
[CWI.insert] Compound Regular Index with 2 fields. Inserting batches of 1000 docs.
1       629.491045794724
2       1194.8517838129765
[CWI.insert] Compound Wildcard Index with 2 fields. Inserting batches of 1 doc.
1       7313.298467546089
2       13065.661304191573
[CWI.insert] Compound Wildcard Index with 2 fields. Inserting batches of 100 docs.
1       2772.96291187096
2       5249.832288417547
[CWI.insert] Compound Wildcard Index with 2 fields. Inserting batches of 1000 docs.
1       629.2657340420768
2       1159.9636439449318
[CWI.insert] Compound Regular Index of with fields, one of which is multikey. Inserting batches of 1 doc.
1       6250.823410590155
2       12780.312713266745
[CWI.insert] Compound Regular Index of with fields, one of which is multikey. Inserting batches of 100 docs.
1       2826.8607751076315
2       5066.412459864582
[CWI.insert] Compound Regular Index of with fields, one of which is multikey. Inserting batches of 1000 docs.
1       618.8734823507117
2       1111.5609937619085
[CWI.insert] Compound Wildcard index with 2 fields, one of which is multikey. Inserting batches of 1 doc.
1       6587.892648058149
2       12912.592771466798
[CWI.insert] Compound Wildcard index with 2 fields, one of which is multikey. Inserting batches of 100 docs.
1       2834.1054684680776
2       5114.502611322789
[CWI.insert] Compound Wildcard index with 2 fields, one of which is multikey. Inserting batches of 1000 docs.
1       620.5221301901008
2       1179.2438688313055
[CWI.insert] Multiple Compound Regular Indexes with 2 fields. Inserting batches of 1 doc.
1       7049.543731921811
2       12558.982360014033
[CWI.insert] Multiple Compound Regular Indexes with 2 fields. Inserting batches of 100 docs.
1       2825.129840816299
2       5231.800841342021
[CWI.insert] Multiple Compound Regular Indexes with 2 fields. Inserting batches of 1000 docs.
1       615.6372665225649
2       1155.1187109842615
[CWI.insert] Compound Wildcard Index with 2 fields and multiple fields in the projection. Inserting batches of 1 doc.
1       7329.074400961428
2       12910.624992254903
[CWI.insert] Compound Wildcard Index with 2 fields and multiple fields in the projection. Inserting batches of 100 docs.
1       2842.0081391594335
2       5270.966788971645
[CWI.insert] Compound Wildcard Index with 2 fields and multiple fields in the projection. Inserting batches of 1000 docs.
1       618.1733776397572
2       1122.264692173688
[CWI.insert] Compound Regular Index with 5 fields. Inserting batches of 1 doc.
1       7246.030557564288
2       12449.75520279028
[CWI.insert] Compound Regular Index with 5 fields. Inserting batches of 100 docs.
1       2761.79084162647
2       5039.366742298142
[CWI.insert] Compound Regular Index with 5 fields. Inserting batches of 1000 docs.
1       621.0236596622447
2       1140.1717653572882
[CWI.insert] Compound Wildcard Index with 5 fields. Inserting batches of 1 doc.
1       7308.386520980097
2       12755.666547594323
[CWI.insert] Compound Wildcard Index with 5 fields. Inserting batches of 100 docs.
1       2840.0310432226097
2       5280.814898222678
[CWI.insert] Compound Wildcard Index with 5 fields. Inserting batches of 1000 docs.
1       631.211047752375
2       1214.6926246094167