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 | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: | 2d9fea95335ab8f399868f63c51bee89 |
| User & Date: | drh 2008-03-29 17:26:02 |
Context
|
2008-03-29
| ||
| 23:25 | Minor cleanup: Use size_t for struct size cast (CVS 4940) check-in: 618df68b user: mlcreech tags: trunk | |
| 17:26 | Set exclusive locking mode by default on the speed4p test. (CVS 4939) check-in: 2d9fea95 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: 9b567ab6 user: drh tags: trunk | |
Changes
Changes to test/speed4p.test.
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
..
86
87
88
89
90
91
92
93
94
95
96
97
98
99
|
# the focus is on the speed of: # # * joins # * views # * sub-selects # * triggers # # $Id: speed4p.test,v 1.1 2008/03/27 15:07:05 drh Exp $ # set testdir [file dirname $argv0] source $testdir/tester.tcl speed_trial_init speed1 # Set a uniform random seed ................................................................................ # 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; |
|
>
>
>
|
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
..
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
|
# 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 ................................................................................ # 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; |