Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Fix a bug in the speed4p.test performance testing script. (CVS 4971) |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: | 80311594149af093f1719ec433a633c3 |
| User & Date: | drh 2008-04-10 13:20:21 |
Context
|
2008-04-10
| ||
| 13:32 | Add three new test cases to speed4p.test. Two of the three do single-row updates based on rowid and on primary key. (CVS 4972) check-in: a2da7f9a user: drh tags: trunk | |
| 13:20 | Fix a bug in the speed4p.test performance testing script. (CVS 4971) check-in: 80311594 user: drh tags: trunk | |
|
2008-04-08
| ||
| 03:09 | Replace always-true condition with assertion (CVS 4970) check-in: be7f3240 user: mlcreech tags: trunk | |
Changes
Changes to test/speed4p.test.
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
...
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
|
# the focus is on the speed of: # # * joins # * views # * sub-selects # * triggers # # $Id: speed4p.test,v 1.2 2008/03/29 17:26:02 drh Exp $ # set testdir [file dirname $argv0] source $testdir/tester.tcl speed_trial_init speed1 # Set a uniform random seed ................................................................................ execsql { CREATE INDEX i1 ON t1(t); CREATE INDEX i2 ON t2(t); CREATE INDEX i3 ON t3(t); COMMIT; } # Before running these tests, disable the compiled statement cache built into # the Tcl interface. This is because we want to test the speed of SQL # compilation as well as execution. # db cache size 0 # Join t1, t2, t3 on IPK. set sql "SELECT * FROM t1, t2, t3 WHERE t1.oid = t2.oid AND t2.oid = t3.oid" speed_trial speed4p-join1 50000 row $sql # Join t1, t2, t3 on the non-IPK index. set sql "SELECT * FROM t1, t2, t3 WHERE t1.t = t2.t AND t2.t = t3.t" speed_trial speed4p-join2 50000 row $sql |
|
<
<
<
<
<
<
|
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
...
113
114
115
116
117
118
119
120
121
122
123
124
125
126
|
# the focus is on the speed of: # # * joins # * views # * sub-selects # * triggers # # $Id: speed4p.test,v 1.3 2008/04/10 13:20:21 drh Exp $ # set testdir [file dirname $argv0] source $testdir/tester.tcl speed_trial_init speed1 # Set a uniform random seed ................................................................................ execsql { CREATE INDEX i1 ON t1(t); CREATE INDEX i2 ON t2(t); CREATE INDEX i3 ON t3(t); COMMIT; } # Join t1, t2, t3 on IPK. set sql "SELECT * FROM t1, t2, t3 WHERE t1.oid = t2.oid AND t2.oid = t3.oid" speed_trial speed4p-join1 50000 row $sql # Join t1, t2, t3 on the non-IPK index. set sql "SELECT * FROM t1, t2, t3 WHERE t1.t = t2.t AND t2.t = t3.t" speed_trial speed4p-join2 50000 row $sql |