OLD | NEW |
1 | 1 |
2 set testdir [file join [file dirname $argv0] .. .. test] | 2 set testdir [file join [file dirname $argv0] .. .. test] |
3 source $testdir/tester.tcl | 3 source $testdir/tester.tcl |
4 | 4 |
5 ifcapable !rtree { | 5 ifcapable !rtree { |
6 finish_test | 6 finish_test |
7 return | 7 return |
8 } | 8 } |
9 | 9 |
10 set NROW 10000 | 10 set NROW 10000 |
(...skipping 54 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
65 puts "$btree_select_time" | 65 puts "$btree_select_time" |
66 | 66 |
67 puts -nonewline "Selecting from rtree... " | 67 puts -nonewline "Selecting from rtree... " |
68 flush stdout | 68 flush stdout |
69 set rtree_select_time [time { | 69 set rtree_select_time [time { |
70 foreach {x1 x2 y1 y2} [lrange $data 0 [expr $NQUERY*4-1]] { | 70 foreach {x1 x2 y1 y2} [lrange $data 0 [expr $NQUERY*4-1]] { |
71 db eval {SELECT * FROM rtree WHERE x1<$x1 AND x2>$x2 AND y1<$y1 AND y2>$y2} | 71 db eval {SELECT * FROM rtree WHERE x1<$x1 AND x2>$x2 AND y1<$y1 AND y2>$y2} |
72 } | 72 } |
73 }] | 73 }] |
74 puts "$rtree_select_time" | 74 puts "$rtree_select_time" |
OLD | NEW |