Lines Matching refs:sql

29 proc tracesql {sql} {
30   puts $::sqlout $sql\;
88 set sql {}
91   append sql "INSERT INTO t1 VALUES($i,$r,'[number_name $r]');\n"
94 speed_trial speed1-insert1 50000 row $sql
99 set sql {}
102   append sql "INSERT INTO t2 VALUES($i,$r,'[number_name $r]');\n"
105 speed_trial speed1-insert2 50000 row $sql
113 set sql {}
117   append sql "SELECT count(*), avg(b) FROM t1 WHERE b>=$lwr AND b<$upr;"
120 speed_trial speed1-select1 [expr {50*50000}] row $sql
126 set sql {}
128   append sql \
132 speed_trial speed1-select2 [expr {50*50000}] row $sql
148 set sql {}
152   append sql "SELECT count(*), avg(b) FROM t1 WHERE b>=$lwr AND b<$upr;"
155 speed_trial speed1-select3 5000 stmt $sql
160 set sql {}
163   append sql "SELECT c FROM t1 WHERE rowid=$id;"
166 speed_trial speed1-select4 100000 row $sql
171 set sql {}
174   append sql "SELECT c FROM t1 WHERE a=$id;"
177 speed_trial speed1-select5 100000 row $sql
182 set sql {}
184   append sql "SELECT c FROM t1 WHERE c='$c';"
187 speed_trial speed1-select6 50000 row $sql
196 set sql {}
200   append sql "UPDATE t1 SET b=b*2 WHERE a>=$lwr AND a<$upr;"
203 speed_trial speed1-update1 5000 stmt $sql
208 set sql {}
211   append sql "UPDATE t1 SET b=$r WHERE a=$i;"
214 speed_trial speed1-update2 50000 row $sql
226 set sql {}
229   append sql "UPDATE t1 SET c='[number_name $r]' WHERE a=$i;"
232 speed_trial speed1-update4 50000 row $sql