Lines Matching refs:sql

25 proc tracesql {sql} {
26   puts $::sqlout $sql\;
84 set sql {}
87   append sql "INSERT INTO t1 VALUES($i,$r,'[number_name $r]');\n"
90 speed_trial speed2-insert1 50000 row $sql
95 set sql {}
98   append sql "INSERT INTO t2 VALUES($i,$r,'[number_name $r]');\n"
101 speed_trial speed2-insert2 50000 row $sql
109 set sql {}
113   append sql "SELECT count(*), avg(b) FROM t1 WHERE b>=$lwr AND b<$upr;"
115 speed_trial speed2-select1a [expr {50*50000}] row $sql
120 set sql {}
122   append sql \
125 speed_trial speed2-select2a [expr {50*50000}] row $sql
133 set sql {}
137   append sql "SELECT count(*), avg(b) FROM t1 WHERE b>=$lwr AND b<$upr;"
139 speed_trial speed2-select1b [expr {50*50000}] row $sql
144 set sql {}
146   append sql \
149 speed_trial speed2-select2b [expr {50*50000}] row $sql
164 set sql {}
168   append sql "SELECT count(*), avg(b) FROM t1 WHERE b>=$lwr AND b<$upr;"
170 speed_trial speed2-select3a 5000 stmt $sql
174 set sql {}
177   append sql "SELECT c=='hi' FROM t1 WHERE rowid=$id;\n"
179 speed_trial speed2-select4a 100000 row $sql
183 set sql {}
186   append sql "SELECT c FROM t1 WHERE a=$id;"
188 speed_trial speed2-select5a 100000 row $sql
192 set sql {}
194   append sql "SELECT c FROM t1 WHERE c='$c';"
196 speed_trial speed2-select6a 50000 row $sql
205 set sql {}
209   append sql "SELECT count(*), avg(b) FROM t1 WHERE b>=$lwr AND b<$upr;"
211 speed_trial speed2-select3b 5000 stmt $sql
215 set sql {}
218   append sql "SELECT c=='hi' FROM t1 WHERE rowid=$id;\n"
220 speed_trial speed2-select4b 100000 row $sql
224 set sql {}
227   append sql "SELECT c FROM t1 WHERE a=$id;"
229 speed_trial speed2-select5b 100000 row $sql
233 set sql {}
235   append sql "SELECT c FROM t1 WHERE c='$c';"
237 speed_trial speed2-select6b 50000 row $sql
241 set sql {}
245   append sql "UPDATE t1 SET b=b*2 WHERE a>=$lwr AND a<$upr;"
248 speed_trial speed2-update1 5000 stmt $sql
253 set sql {}
256   append sql "UPDATE t1 SET b=$r WHERE a=$i;"
259 speed_trial speed2-update2 50000 row $sql
271 set sql {}
274   append sql "UPDATE t1 SET c='[number_name $r]' WHERE a=$i;"
277 speed_trial speed2-update4 50000 row $sql