Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Set exclusive locking mode by default on the speed4p test. (CVS 4939) |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
2d9fea95335ab8f399868f63c51bee89 |
User & Date: | drh 2008-03-29 17:26:02.000 |
Context
2008-03-29
| ||
23:25 | Minor cleanup: Use size_t for struct size cast (CVS 4940) (check-in: 618df68b8b user: mlcreech tags: trunk) | |
17:26 | Set exclusive locking mode by default on the speed4p test. (CVS 4939) (check-in: 2d9fea9533 user: drh tags: trunk) | |
16:01 | Make the sqlite3BtreeMoveto routine a no-op if the cursor is already pointing at the cell we are trying to move to. (CVS 4938) (check-in: 9b567ab61e user: drh 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.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 |
︙ | ︙ | |||
86 87 88 89 90 91 92 93 94 95 96 97 98 99 | # speed4p-notrigger2: " trigger2 " # speed4p-notrigger3: " trigger3 " # # Set up the schema. Each of the tables t1, t2 and t3 contain 50,000 rows. # This creates a database of around 16MB. execsql { BEGIN; CREATE TABLE t1(rowid INTEGER PRIMARY KEY, i INTEGER, t TEXT); CREATE TABLE t2(rowid INTEGER PRIMARY KEY, i INTEGER, t TEXT); CREATE TABLE t3(rowid INTEGER PRIMARY KEY, i INTEGER, t TEXT); CREATE VIEW v1 AS SELECT rowid, i, t FROM t1; CREATE VIEW v2 AS SELECT rowid, i, t FROM t2; | > > > | 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 | # speed4p-notrigger2: " trigger2 " # speed4p-notrigger3: " trigger3 " # # Set up the schema. Each of the tables t1, t2 and t3 contain 50,000 rows. # This creates a database of around 16MB. execsql { PRAGMA page_size=1024; PRAGMA cache_size=8192; PRAGMA locking_mode=EXCLUSIVE; BEGIN; CREATE TABLE t1(rowid INTEGER PRIMARY KEY, i INTEGER, t TEXT); CREATE TABLE t2(rowid INTEGER PRIMARY KEY, i INTEGER, t TEXT); CREATE TABLE t3(rowid INTEGER PRIMARY KEY, i INTEGER, t TEXT); CREATE VIEW v1 AS SELECT rowid, i, t FROM t1; CREATE VIEW v2 AS SELECT rowid, i, t FROM t2; |
︙ | ︙ |