jstests/core/distinct_speed1.js


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25


t = db.distinct_speed1;

t.drop();
for (var i = 0; i < 10000; i++) {
    t.save({x: i % 10});
}

assert.eq(10, t.distinct("x").length, "A1");

function fast() {
    t.find().explain("executionStats").executionStats.executionTimeMillis;
}

function slow() {
    t.distinct("x");
}

for (i = 0; i < 3; i++) {
    print("it: " + Date.timeFunc(fast));
    print("di: " + Date.timeFunc(slow));
}

t.ensureIndex({x: 1});
t.distinct("x", {x: 5});