/ File History
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

History of src/pcache.h

2018-11-22
19:10
Fix a problem reading from temp databases in SQLITE_DIRECT_OVERFLOW_READ builds. file: [4f87acd9] check-in: [81629ba9] user: dan branch: trunk, size: 6913
2017-09-01
12:18
Small size and performance improvement in pcacheManageDirtyList() by not zeroing the PgHdr.pDirtyNext and PgHdr.pDirtyPrev pointers for PgHdr objects that are not on the dirty list. file: [072f94d2] check-in: [919863b1] user: drh branch: trunk, size: 6828
2017-05-31
03:20
Reorder fields in the PgHdr object for a performance increase. file: [521bb961] check-in: [326e63d7] user: drh branch: trunk, size: 6690
2016-05-13
15:22
Remove the unused PGHDR_NEED_READ flag. Add invariant checking (during SQLITE_DEBUG builds only) for the PgHdr object. file: [2cedcd84] check-in: [771c5411] user: drh branch: trunk, size: 6601
2016-05-11
23:54
For in-memory databases, it does not matter if pcache entries are marked "clean" or "writable". file: [33b40350] check-in: [ad601c79] user: drh branch: pager-dev, size: 6550
2016-04-21
15:24
Add a function prototype in order to fix a compiler warning. file: [6b865be7] check-in: [49aec971] user: drh branch: tempfiles-25, size: 6541
2016-04-13
16:52
On commit, flush dirty temp-file pages only if the file is already open and 25% or more of the cache is dirty. file: [60bc9893] check-in: [f6babf29] user: dan branch: tempfiles-25, size: 6499
2016-01-09
16:39
If a single page is written to the wal file more than once, have each subsequent copy overwrite the original frame. file: [4d0ccaad] check-in: [5d113aef] user: dan branch: wal-overwrite-frames, size: 6385
2015-11-12
14:57
First attempt at enhancing the "PRAGMA cache_spill" statement to accept a cache threashold size. file: [1ff11adc] check-in: [549d42be] user: drh branch: cache_spill=N, size: 6320
2015-06-29
18:29
Add the PGHDR_WRITEABLE bit for PgHdr.flags which is used to distinguish between pages that are on the dirty list and pages that are safe to modify. file: [99686037] check-in: [7c4ef7b7] user: drh branch: trunk, size: 6065
04:21
Add the new PGHDR_CLEAN bit to PgHdr.flags in pcache.c. This bit is always the opposite of PGHDR_DIRTY. Use the extra bit to avoid a comparison for a small performance boost. file: [445374bc] check-in: [8619fc34] user: drh branch: trunk, size: 6048
2014-11-04
12:11
Add the SQLITE_CONFIG_PCACHE_HDRSZ option for sqlite3_config(). file: [b44658c9] check-in: [6eb03e62] user: drh branch: trunk, size: 5985
2014-08-27
23:18
Refactor the sqlite3PcacheFetch() routine into three separate routines, which are significantly faster overall and about 100 bytes smaller in size as well. file: [9b559127] check-in: [bdb6e497] user: drh branch: trunk, size: 5884
2014-08-26
15:06
Change the page cache so that a new sqlite3_pcache object is allocated as soon as the page cache is opened, not delayed until the first fetch request. This give a noticable performance boost. The interface between pager and the page cache has changed slightly, which might break ZIPVFS. file: [80a9c3f7] check-in: [f1f94a97] user: drh branch: trunk, size: 5732
2013-03-14
18:34
Use mmap() to read from the database file in rollback mode. This branch is unix only for now. file: [a5e4f5d9] check-in: [6f21d9cb] user: dan branch: experimental-mmap, size: 5734
2012-02-02
15:50
Data structure cleanup. Remove unused fields. Rearrange other files for tighter packing and reduced memory usage. file: [1b5dcc3d] check-in: [0bc594e8] user: drh branch: trunk, size: 5660
2011-11-16
19:29
Add the sqlite3_db_release_memory() interface and the shrink_memory pragma. file: [b1d8775a] check-in: [3f58e7c8] user: drh branch: trunk, size: 5660
2011-11-14
01:55
Begin making experimental changes to use mmap() for reading content from a database. The code compiles, but crashes on the test suite. file: [f8a98a37] check-in: [09be42d5] user: drh branch: mmap-experimental, size: 5648
2011-11-08
20:08
Experimental change to the pcache interface to allow page buffers to be allocated separately from their associated container structures. file: [c770382f] check-in: [c275c9d3] user: dan branch: experimental-pcache, size: 5563
2009-11-10
01:30
Remove the obsolete "$Id:$" RCS identifier strings from the source code. file: [c683390d] check-in: [f6c045f6] user: drh branch: trunk, size: 5509
2009-07-25
11:46
Add files that should have gone in with the previous checkin. (CVS 6935) file: [435ef324] check-in: [64c7afc7] user: danielk1977 branch: trunk, size: 5579
2009-01-20
17:06
Big change to make pager.c easier to follow. Unused variables removed, comments improved, etc. (CVS 6197) file: [9b927ccc] check-in: [12f7346c] user: danielk1977 branch: trunk, size: 5548
2009-01-16
16:23
Revert (6187). (CVS 6188) file: [00adba50] check-in: [a353c1ab] user: danielk1977 branch: trunk, size: 5547
15:21
This commit is an error. Reverted by (6188). (CVS 6187) file: [a56b8998] check-in: [aa67fd0c] user: danielk1977 branch: trunk, size: 5548
2008-11-19
16:52
Fix some compiler warnings that show up when building the amalgamation only. (CVS 5927) file: [f20c3e82] check-in: [d1abe8a1] user: danielk1977 branch: trunk, size: 5547
2008-11-13
14:28
Add an API to support custom page cache implementations. (CVS 5899) file: [b6feb183] check-in: [47866d67] user: danielk1977 branch: trunk, size: 5692
2008-10-17
18:51
Add "pragma journal_mode=memory". Change the way rollback works for in-memory databases so that it reuses the journal_mode=memory code. (CVS 5830) file: [2caf2deb] check-in: [39ebf01a] user: danielk1977 branch: trunk, size: 6260
2008-10-11
17:42
Conditionally omit prototypes in pcache.h when the corresponding routines are not used. Ticket #3430. (CVS 5805) file: [974d8ba6] check-in: [977ae12c] user: drh branch: trunk, size: 6620
2008-09-29
11:49
Instead of storing a pointer to the parent page in the MemPage structure, have each B-Tree cursor keep track of the ancestry of the current page. (CVS 5747) file: [28d9ce2d] check-in: [40425e93] user: danielk1977 branch: trunk, size: 6523
2008-09-18
17:34
Avoid parsing the structure of b-tree pages (in sqlite3BtreeInitPage) more than is necessary. (CVS 5720) file: [0b6871e8] check-in: [6b998f30] user: danielk1977 branch: trunk, size: 6547
2008-09-17
20:06
Speed improvements for in-memory databases by omitting flag clearing on pages where it is impossible for the flag to be set and by avoiding assert()s on non-debugging builds. Ticket #3384. (CVS 5715) file: [deddea69] check-in: [a7fd9e62] user: drh branch: trunk, size: 6546
2008-08-29
09:10
If a page is made eligible for recycling when more than the configured maximum number of pages are allocated, free it immediately instead of adding it to the LRU list. (CVS 5638) file: [53730c33] check-in: [4b12922d] user: danielk1977 branch: trunk, size: 6547
2008-08-28
02:26
Miscellaneous cleanup in the new pcache code. (CVS 5629) file: [bd373ee3] check-in: [da177725] user: drh branch: trunk, size: 6492
2008-08-27
15:16
Use a bitvec object to store the set of pages with the 'always-rollback' property for a transaction. (CVS 5622) file: [7a50b77f] check-in: [9e932599] user: danielk1977 branch: trunk, size: 5987
2008-08-26
18:05
Simplify the pcache module by only recycling clean pages from 'other' caches. This commit causes errors in test files ioerr5.test and malloc5.test because they test recycling dirty pages from other caches. (CVS 5615) file: [3531f83e] check-in: [9e511e16] user: danielk1977 branch: trunk, size: 6057
2008-08-23
18:53
Instead of marking a page as clean when sqlite3PagerDontWrite() is called, set a dedictated flag - PGHDR_DONT_WRITE. (CVS 5604) file: [f03fc3b8] check-in: [a323bd29] user: danielk1977 branch: trunk, size: 6732
2008-08-22
16:22
When recycling a page, try to find one that does not require a call to xSync() on the journal file. Also simplify some of the mutex related things in pcache. (CVS 5597) file: [1457e4e7] check-in: [93dbc542] user: danielk1977 branch: trunk, size: 6659
2008-08-21
20:21
Move date+time functions to start-time initialization. Additional start-time function cleanup. (CVS 5585) file: [d2becbe7] check-in: [80d6a31c] user: drh branch: trunk, size: 6740
12:19
Fix the functionality associated with sqlite3_release_memory() and sqlite3_soft_heap_limit(). It is automatically disabled if the SQLITE_CONFIG_PAGECACHE option is used. (CVS 5576) file: [aef1dedd] check-in: [d025866b] user: danielk1977 branch: trunk, size: 6749
2008-08-20
14:49
Add the pcache module from the experimental branch. Also change things so that most of the built-in SQL functions are kept in single static hash-table, rather than creating and populating a separate hash table for each open database connection. (CVS 5566) file: [71ade7a8] check-in: [cb494e10] user: danielk1977 branch: trunk, size: 6711 Added