OLD | NEW |
1 # 2007 May 17 | 1 # 2007 May 17 |
2 # | 2 # |
3 # The author disclaims copyright to this source code. In place of | 3 # The author disclaims copyright to this source code. In place of |
4 # a legal notice, here is a blessing: | 4 # a legal notice, here is a blessing: |
5 # | 5 # |
6 # May you do good and not evil. | 6 # May you do good and not evil. |
7 # May you find forgiveness for yourself and forgive others. | 7 # May you find forgiveness for yourself and forgive others. |
8 # May you share freely, never taking more than you give. | 8 # May you share freely, never taking more than you give. |
9 # | 9 # |
10 #************************************************************************* | 10 #************************************************************************* |
(...skipping 98 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
109 db close | 109 db close |
110 sqlite3 db test.db | 110 sqlite3 db test.db |
111 db eval { | 111 db eval { |
112 PRAGMA main.cache_size = 200000; | 112 PRAGMA main.cache_size = 200000; |
113 PRAGMA main.auto_vacuum = 'incremental'; | 113 PRAGMA main.auto_vacuum = 'incremental'; |
114 ATTACH 'test2.db' AS 'aux'; | 114 ATTACH 'test2.db' AS 'aux'; |
115 PRAGMA aux.auto_vacuum = 'none'; | 115 PRAGMA aux.auto_vacuum = 'none'; |
116 } | 116 } |
117 } | 117 } |
118 | 118 |
119 file delete -force test2.db test2.db-journal | 119 forcedelete test2.db test2.db-journal |
120 reset_db | 120 reset_db |
121 | 121 |
122 # Set up a database in auto-vacuum mode and create a database schema. | 122 # Set up a database in auto-vacuum mode and create a database schema. |
123 # | 123 # |
124 do_test speed3-0.1 { | 124 do_test speed3-0.1 { |
125 execsql { | 125 execsql { |
126 CREATE TABLE main.t1(a INTEGER, b TEXT, c INTEGER); | 126 CREATE TABLE main.t1(a INTEGER, b TEXT, c INTEGER); |
127 } | 127 } |
128 execsql { | 128 execsql { |
129 SELECT name FROM sqlite_master ORDER BY 1; | 129 SELECT name FROM sqlite_master ORDER BY 1; |
(...skipping 33 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
163 # chain) from each table row. | 163 # chain) from each table row. |
164 # | 164 # |
165 #db eval {PRAGMA incremental_vacuum(500000)} | 165 #db eval {PRAGMA incremental_vacuum(500000)} |
166 populate_t1 db | 166 populate_t1 db |
167 reset_db | 167 reset_db |
168 speed_trial speed3-2.incrvacuum $::NROW row {SELECT c FROM main.t1} | 168 speed_trial speed3-2.incrvacuum $::NROW row {SELECT c FROM main.t1} |
169 speed_trial speed3-2.normal $::NROW row {SELECT c FROM aux.t1} | 169 speed_trial speed3-2.normal $::NROW row {SELECT c FROM aux.t1} |
170 io_log db | 170 io_log db |
171 | 171 |
172 finish_test | 172 finish_test |
OLD | NEW |