File: queryoptimizer1.js

package info (click to toggle)
mongodb 1%3A1.4.4-3
  • links: PTS
  • area: main
  • in suites: squeeze
  • size: 6,816 kB
  • ctags: 11,368
  • sloc: cpp: 58,805; ansic: 18,160; python: 1,255; sh: 238; makefile: 82
file content (26 lines) | stat: -rw-r--r-- 568 bytes parent folder | download | duplicates (2) 
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
 

t = db.queryoptimizer1;
t.drop()

for ( i=0; i<1000; i++ )
    for ( j=0; j<20; j++ )
        t.save( { a : i , b : i , c : j } )


t.ensureIndex( { a : 1 } )
t.ensureIndex( { b : 1 } )

for ( ; i<2000; i++ )
    for ( j=0; j<20; j++ )
        t.save( { a : i , b : i , c : j } )


printjson( t.find( { a : 50 , b : 50 , c : 6 } ).explain() );

for ( var i=0; i<10000; i++ ){
    a = t.find( { a : 50 , b : 50 , c : i % 20 } ).toArray();
}

printjson( t.find( { a : 50 , b : 50 , c : 6 } ).explain() );
assert.eq( 1 , t.find( { a : 50 , b : 50 , c : 6 } ).count() )