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
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
|
/**
* Performance tests for various finders
*/
var calls = 100;
var size = 500000;
var collection_name = "sort2";
function testSetup(dbConn) {
var t = dbConn[collection_name];
t.drop();
for (var i=0; i<size; i++){
t.save({ num : i });
if (i == 0 )
t.ensureIndex( { num : 1 } );
}
}
function resetQueryCache( db ) {
db[ collection_name ].createIndex( { a: 1 }, "dumbIndex" );
db[ collection_name ].dropIndex( "dumbIndex" );
}
function between( low, high, val, msg ) {
assert( low < val, msg );
assert( val < high, msg );
}
/**
* Tests fetching a set of 10 objects in sorted order, comparing getting
* from front of collection vs end, using $lt
*/
function testFindLTFrontBack(dbConn) {
var results = {};
var t = dbConn[collection_name];
resetQueryCache( dbConn );
results.oneInOrderLTFirst = Date.timeFunc(
function(){
assert( t.find( { num : {$lt : 20} } ).sort( { num : 1 } ).limit(10).toArray().length == 10);
} , calls );
resetQueryCache( dbConn );
results.oneInOrderLTLast = Date.timeFunc(
function(){
assert( t.find( { num : {$lt : size-20 }} ).sort( { num : 1 } ).limit(10).toArray().length == 10);
} , calls );
between( 0.9, 1.1, results.oneInOrderLTFirst / results.oneInOrderLTLast,
"first / last (" + results.oneInOrderLTFirst + " / " + results.oneInOrderLTLast + " ) = " +
results.oneInOrderLTFirst / results.oneInOrderLTLast + " not in [0.9, 1.1]" );
}
/**
* Tests fetching a set of 10 objects in sorted order, comparing getting
* from front of collection vs end
*/
function testFindGTFrontBack(dbConn) {
var results = {};
var t = dbConn[collection_name];
resetQueryCache( dbConn );
results.oneInOrderGTFirst = Date.timeFunc(
function(){
assert( t.find( { num : {$gt : 5} } ).sort( { num : 1 } ).limit(10).toArray().length == 10);
} , calls );
resetQueryCache( dbConn );
results.oneInOrderGTLast = Date.timeFunc(
function(){
assert( t.find( { num : {$gt : size-20 }} ).sort( { num : 1 } ).limit(10).toArray().length == 10);
} , calls );
between( 0.25, 4.0, results.oneInOrderGTFirst / results.oneInOrderGTLast,
"first / last (" + results.oneInOrderGTFirst + " / " + results.oneInOrderGTLast + " ) = " +
results.oneInOrderGTFirst / results.oneInOrderGTLast + " not in [0.25, 4.0]" );
}
testSetup(db);
testFindLTFrontBack(db);
testFindGTFrontBack(db);
|