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 |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
80311594149af093f1719ec433a633c3 |
User & Date: | drh 2008-04-10 13:20:21.000 |
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: a2da7f9ac2 user: drh tags: trunk) | |
13:20 | Fix a bug in the speed4p.test performance testing script. (CVS 4971) (check-in: 8031159414 user: drh tags: trunk) | |
2008-04-08
| ||
03:09 | Replace always-true condition with assertion (CVS 4970) (check-in: be7f3240c2 user: mlcreech tags: trunk) | |
Changes
Changes to test/speed4p.test.
︙ | ︙ | |||
13 14 15 16 17 18 19 | # the focus is on the speed of: # # * joins # * views # * sub-selects # * triggers # | | | 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 | # 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 |
︙ | ︙ | |||
113 114 115 116 117 118 119 | execsql { CREATE INDEX i1 ON t1(t); CREATE INDEX i2 ON t2(t); CREATE INDEX i3 ON t3(t); COMMIT; } | < < < < < < | 113 114 115 116 117 118 119 120 121 122 123 124 125 126 | 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 |
︙ | ︙ |