Lines Matching refs:cache

12 # $Id: cache.test,v 1.4 2007/08/22 02:56:44 drh Exp $
32   do_test cache-1.1 { pager_cache_size db } {0}
35 do_test cache-1.2 {
44 # At one point, repeatedly locking and unlocking the cache was causing
46 # leaked, but would not be reused until the pager-cache was full (i.e. 
49 # This tests that once the pager-cache is initialized, it can be locked
54   do_test cache-1.3.$ii {
64 #   cache-2.1.*: Test that "PRAGMA cache_size" appears to work with small 
66 #   cache-2.2.*: Test that "PRAGMA main.cache_size" appears to work with 
68 #   cache-2.3.*: Test cache_size=1 correctly spills/flushes the cache. 
69 #   cache-2.4.*: Test cache_size=0 correctly spills/flushes the cache. 
73 do_execsql_test cache-2.0 {
83   do_execsql_test cache-2.1.$i.1 "PRAGMA cache_size = $i"
84   do_execsql_test cache-2.1.$i.2 "PRAGMA cache_size" $i
85   do_execsql_test cache-2.1.$i.3 "SELECT * FROM t1" {x y}
86   do_execsql_test cache-2.1.$i.4 "PRAGMA cache_size" $i
89   do_execsql_test cache-2.2.$i.1 "PRAGMA main.cache_size = $i"
90   do_execsql_test cache-2.2.$i.2 "PRAGMA main.cache_size" $i
91   do_execsql_test cache-2.2.$i.3 "SELECT * FROM t1" {x y}
92   do_execsql_test cache-2.2.$i.4 "PRAGMA main.cache_size" $i
97 do_execsql_test cache-2.3.1 {
103 do_test cache-2.3.2 { pager_cache_size db } 2
104 do_execsql_test cache-2.3.3 {
108 do_test cache-2.3.4 { pager_cache_size db } 2
109 do_execsql_test cache-2.3.5 COMMIT
110 do_test cache-2.3.6 { pager_cache_size db } 1
112 do_execsql_test cache-2.3.7 {
115 do_test cache-2.3.8 { pager_cache_size db } 1
119 do_execsql_test cache-2.4.1 {
125 do_test cache-2.4.2 { pager_cache_size db } 2
126 do_execsql_test cache-2.4.3 {
130 do_test cache-2.4.4 { pager_cache_size db } 2
131 do_execsql_test cache-2.4.5 COMMIT
133 do_test cache-2.4.6 { pager_cache_size db } 0
134 do_execsql_test cache-2.4.7 {
137 do_test cache-2.4.8 { pager_cache_size db } 0