Home
last modified time | relevance | path

Searched refs:cache (Results 1 – 25 of 150) sorted by relevance

123456

/sqlite-3.40.0/test/
H A Dcache.test35 do_test cache-1.2 {
54 do_test cache-1.3.$ii {
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 {
97 do_execsql_test cache-2.3.1 {
104 do_execsql_test cache-2.3.3 {
112 do_execsql_test cache-2.3.7 {
119 do_execsql_test cache-2.4.1 {
126 do_execsql_test cache-2.4.3 {
[all …]
H A Dmalloc5.test66 # one unused page in a single pager cache. The page cannot be freed, as
87 # in the cache belonging to db2.
94 # Commit the transaction and open a new one. Read 1 page into the cache.
132 # pages currently in the cache are dirty (page 3) or pinned (page 1).
229 db cache flush
239 db cache flush
355 # This time, 3 pages should be pulled from the db cache.
362 # Now open a transaction and update 2 pages in the db2 cache. Then
368 # btree layer holds a reference to page 1 in the db2 cache.
393 # the rest of the db cache. But the db2 cache remains intact, because
[all …]
H A De_uri.test353 1 {file:test.db?cache=private} {not an error}
354 2 {file:test.db?cache=shared} {not an error}
355 3 {file:test.db?cache=yes} {no such cache mode: yes}
356 4 {file:test.db?cache=} {no such cache mode: }
383 2.1 "file:test.db?cache=private" "" 0 0
384 2.2 "file:test.db?cache=private" "" 1 0
385 2.3 "file:test.db?cache=private" private 0 0
386 2.4 "file:test.db?cache=private" private 1 0
387 2.5 "file:test.db?cache=private" shared 0 0
388 2.6 "file:test.db?cache=private" shared 1 0
[all …]
H A Dtemptrigger.test22 # temptrigger-1.*: Shared cache problem.
23 # temptrigger-2.*: A similar shared cache problem.
29 # in shared-cache mode. If process 1 connections to a shared-cache and
30 # creates a temp trigger, the temp trigger is linked into the shared-cache
31 # schema. If process 2 reloads the shared-cache schema from disk, then
35 # temptrigger-1.1: In shared cache mode, create a table in the main
41 # same shared cache.
43 # temptrigger-1.3: Using the second connection to the shared-cache, cause
44 # the shared-cache schema to be reloaded.
82 # Cause the shared-cache schema to be reloaded.
[all …]
H A Dtkt2854.test25 # Open 3 database connections. Connection "db" and "db2" share a cache.
26 # Connection "db3" has its own cache.
31 sqlite3 db3 "file:test.db?cache=private" -uri 1
39 # shared-cache connection has a read-lock on a table.
60 # Check that an exclusive lock prevents other shared-cache users from
83 # Check that an exclusive lock prevents other shared-cache users from
106 # a cache with "db"). The database should be locked.
119 # shared-cache users is correctly cleared.
H A Dshared3.test67 # The cache-size should now be 10 pages. However at one point there was
68 # a bug that caused the cache size to return to the default value when
69 # a second connection was opened on the shared-cache (as happened in
71 # ensure that the cache-size really is 10 pages.
80 sqlite3 db3 "file:./test.db?cache=private" -uri 1
96 # If the pager-cache is really still limited to 10 pages, then the INSERT
98 # on the database file so that the cache could be spilled.
100 catch { sqlite3 db3 "file:./test.db?cache=private" -uri 1 }
H A Dexclusive2.test36 # This module does not work right if the cache spills at unexpected
103 # is still the same. This is because it uses the in-memory cache.
108 # invalid in-memory cache.
110 # This will only work if the database cache is large enough to hold
112 # the cache size must be at least 17. Otherwise, some pages will be
136 # Make sure the pager cache is large enough to store the
189 # still works. It should be accessing the in-memory cache.
191 # entirely from in-memory cache, because it doesn't check the
197 # As above, this test is only applicable if the pager cache is
200 # to prevent memory-induced cache spills.
[all …]
H A Dthread003.test68 # created by the previous block. The connections do not share a cache.
85 # Set the cache size to 15 pages per cache. 30 available globally.
122 # Set the cache size to 15 pages per cache. 30 available globally.
161 # Set the cache size to 15 pages per cache. 30 available globally.
H A Dtkt3793.test30 sqlite3 db1 "file:test.db?cache=private" -uri 1
31 sqlite3 db2 "file:test.db?cache=shared" -uri 1
65 # Set the size of the cache shared by [db1] and [db2] to 10. Then update
66 # more than 10 pages of table t1. At this point the shared-cache will
81 # Run one SELECT query on the shared-cache using [db1], then from within
83 # pages within the cache, each time a new page is read from the database
H A Dstmtvtab1.test26 db cache flush
27 db cache size 20
61 # All statements are still in cache
75 # Flushing the cache clears all of the prepared statements.
77 db cache flush
H A Dtkt2409.test15 # obtain an EXCLUSIVE lock while trying to spill the cache during
23 # tkt-2409-1.*: Cause a cache-spill during an INSERT that is within
29 # an exclusive lock when attempting a cache-spill is no longer an
33 # tkt-2409-2.*: Cause a cache-spill while updating the change-counter
105 # Check the integrity of the cache.
173 # Check the integrity of the cache.
217 # Check the integrity of the cache.
H A Dlookaside.test40 db cache size 4
81 db cache flush
86 db cache flush
91 db cache flush
108 db cache flush
H A Dthread005.test12 # Test a race-condition that shows up in shared-cache mode.
27 # Use shared-cache mode for these tests.
61 # will not use the same pager cache. In this case the next statement
64 # $finished(0) on the shared-cache table t1 and the statement will
76 # This test tries to exercise a race-condition that existed in shared-cache
78 # open on the same shared cache. The schema of the database is:
203 # does not already exist a shared-cache corresponding to that database,
206 # shared-cache.
H A Dtkt-313723c356.test43 # At this point, the cache contains all of table t1 and none of index i1. The
44 # cache is out of date. When the bug existed and the right xShmLock() fails
45 # in the following statement, the internal cache of the WAL header was
46 # being updated, but the contents of the page-cache not flushed. This causes
H A Dpageropt.test37 # (4) The number of cache pages freed
72 # Verify that values remain in cache on for subsequent reads.
81 # If another thread reads the database, the original cache
92 # But if the other thread modifies the database, then the cache
180 # a cold cache, only page 1, the root page of table t1, and the trunk
193 # Now we delete that big entries starting from a cold cache and an
H A Dpragma2.test173 # the ability of the pager to spill dirty cache pages to the database
182 } {main exclusive temp unknown} ;# EXCLUSIVE lock due to cache spill
192 } {0 main reserved temp unknown} ;# No cache spill, so no exclusive lock
196 # pragma sets a minimum cache size threshold required for spilling to
218 } {50 main exclusive temp unknown} ;# Small cache spill -> exclusive lock
228 } {50 main exclusive temp unknown} ;# Small cache spill -> exclusive lock
H A Dioerr4.test13 # during incremental vacuum with a shared cache.
20 # This test requires both shared cache and incremental vacuum.
27 # Enable shared cache mode and incremental vacuum.
78 # with two connections on shared cache.
H A Dshared.test69 # two connections share a pager cache.
78 # shared-7.*: Autovacuum and shared-cache.
80 # shared-9.*: TEMP triggers and shared-cache databases.
165 sqlite3 db3 "file:test.db?cache=private" -uri 1
563 # other shared-cache users when it reorganizes the database on
769 # correctly when a connection to a shared-cache is closed.
801 sqlite3 db3 "file:test.db?cache=private" -uri 1
1097 # Shared cache on named memory databases.
1125 # Shared cache on named memory databases with different names.
1162 ATTACH 'file:mem?mode=memory&cache=shared' AS shared;
[all …]
H A Ddbstatus.test175 db cache size 0
216 # the page-cache to shrink. So the amount of memory freed is always
322 db cache size 1000
328 db cache flush
338 db cache flush
351 db cache flush
393 sqlite3 db file:test.db?cache=shared
407 sqlite3 db2 file:test.db?cache=shared
412 sqlite3 db file:test.db?cache=shared
H A Dshared9.test13 # to the same shared cache using different database names, views and
65 INSERT INTO t4 VALUES('shared cache');
74 } {{shared cache}}
165 # shared-cache connection to be executed as a result of an sqlite3_step()
189 # cache when it is attempted below.
H A Dindex9.test69 db cache flush
76 db cache flush
90 db cache flush
94 db cache flush
H A Dvacuummem.test13 # frees any memory used for a temporary cache.
28 # temp db is configure with a very small cache). When the VACUUM is
29 # finished and the temp db closed, all the page-cache memory currently
H A Dselect2.test60 # Create a largish table. Do this twice, once using the TCL cache and once
62 # cache turned on.
77 puts "time with cache: $::t1"
92 puts "time without cache: $t2"
/sqlite-3.40.0/ext/wasm/common/
H A Dwhwasmutil.js233 cache.heapSize = 0;
258 }else if(cache.heapSize === cache.memory.buffer.byteLength){
259 return cache;
263 cache.HEAP8 = new Int8Array(b); cache.HEAP8U = new Uint8Array(b);
264 cache.HEAP16 = new Int16Array(b); cache.HEAP16U = new Uint16Array(b);
265 cache.HEAP32 = new Int32Array(b); cache.HEAP32U = new Uint32Array(b);
271 return cache;
327 const c = (cache.memory && cache.heapSize === cache.memory.buffer.byteLength)
646 const c = (cache.memory && cache.heapSize === cache.memory.buffer.byteLength)
679 const c = (cache.memory && cache.heapSize === cache.memory.buffer.byteLength)
[all …]
/sqlite-3.40.0/autoconf/
H A DINSTALL33 It can also use an optional file (typically called `config.cache'
34 and enabled with `--cache-file=config.cache' or simply `-C') that saves
37 cache files.
42 be considered for the next release. If you are using the cache, and at
43 some point `config.cache' contains results you don't want to keep, you
338 `--cache-file=FILE'
339 Enable the cache: use and save the results of the tests in FILE,
340 traditionally `config.cache'. FILE defaults to `/dev/null' to
343 `--config-cache'
345 Alias for `--cache-file=config.cache'.

123456