| 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" |
| 75 | |
| 76 | |
| OLD | NEW |