Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History for src/pcache.c
|
2024-07-17
| ||
| 16:27 | [588cc3c5cc] part of check-in [81b6360050] Add extra assert() statements to the fixes on this branch. (check-in: [81b6360050] user: dan branch: alignment-fixes, size: 31437) | |
|
2023-08-23
| ||
| 10:20 | [040b165f30] part of check-in [bb9dcdaf32] The pageOnDirtyList() assertion is too slow even for debugging builds, for some corner cases. It makes the query appear to hang. So make it an EXPENSIVE_ASSERT instead. (check-in: [bb9dcdaf32] user: drh branch: trunk, size: 31385) | |
|
2023-06-07
| ||
| 08:40 | [4cd4a00431] part of check-in [26c1bb4bd9] Add a C-source spell-checking facility. make misspell (on Nix) (check-in: [26c1bb4bd9] user: larrybr branch: spell-check, size: 31123) | |
|
2023-04-19
| ||
| 18:36 | [8ee13acccf] part of check-in [0a43235b83] Improved rebustness of the pcache tracing logic. (check-in: [0a43235b83] user: drh branch: trunk, size: 31123) | |
| 13:56 | [589326520a] part of check-in [f2d6756731] Fix a debugging printf() in pcache.c. This only comes up on custom builds. (check-in: [f2d6756731] user: drh branch: trunk, size: 31066) | |
|
2023-03-19
| ||
| 21:48 | [842410539b] part of check-in [6c5d99a813] Increase the size of ref-count values in the pager layer to 64-bits, to avoid any reasonable possiblity of overflowing the counters. There is a performance and memory penality for this. Forum post b741f15a35. (check-in: [6c5d99a813] user: drh branch: trunk, size: 31066) | |
|
2022-09-07
| ||
| 19:50 | [5df59c9939] part of check-in [cd1e40064c] Ensure that the Rekey() operation does not overwrite an existing page number. (check-in: [cd1e40064c] user: drh branch: branch-3.39, size: 30176) | |
| 19:28 | [f4268f7f73] part of check-in [7dbddde79e] An improved technique for ensuring that the Rekey() operation does not overwrite an existing page number. This approach does not change the semantics of the underlying pluggable pcache and it is easier to prove correct. This replaces the changes at [aadd38f99a3e5abc] and [81cff9f1955874aa]. (check-in: [7dbddde79e] user: drh branch: trunk, size: 31064) | |
|
2022-09-02
| ||
| 15:19 | [ec6c7b67ea] part of check-in [04eb9f97b9] If sqlite3PcacheMove() moves a page on top of another, swap the two pages, moving the other back to the page number of the original. (check-in: [04eb9f97b9] user: drh branch: branch-3.39-pcache, size: 30151) | |
| 15:09 | [22a6ebe498] part of check-in [81cff9f195] If sqlite3PcacheMove() really performs a swap, then be sure to renumber the second page. (check-in: [81cff9f195] user: drh branch: trunk, size: 31081) | |
|
2022-08-31
| ||
| 00:44 | [78a552ea34] part of check-in [984a07d7f1] Checked in the wrong change by mistake. (check-in: [984a07d7f1] user: drh branch: mistake, size: 29858) | |
|
2022-08-27
| ||
| 16:11 | [5a64e08426] part of check-in [7c96a56c0d] More assert() statements in the page cache. (check-in: [7c96a56c0d] user: drh branch: trunk, size: 30789) | |
| 14:43 | [e82ef04f65] part of check-in [e67f03c166] Ensure that every pcache page always has either the PGHDR_DIRTY or the PGHDR_CLEAN bit set, even during transient page reshuffling during btree balancing. (check-in: [e67f03c166] user: drh branch: trunk, size: 30335) | |
|
2022-03-01
| ||
| 15:48 | [0aab739363] part of check-in [3c9f5c9def] Fix slightly-incorrect assert() statements. Forum post f1e83b77b5ff37db (check-in: [3c9f5c9def] user: drh branch: trunk, size: 29913) | |
|
2021-09-03
| ||
| 18:11 | [084e638432] part of check-in [2262a49467] Fix an assertion fault in pcache introduced by [4bc93658aa563f2f] and detected by OSSFuzz. Test case in TH3. (check-in: [2262a49467] user: drh branch: trunk, size: 29859) | |
|
2020-07-29
| ||
| 16:18 | [8723b98c25] part of check-in [a80ae2c98b] Dozens and dozens of typo fixes in comments. This change adds no value to the end product and is disruptive, so it is questionable whether or not it will ever land on trunk. (check-in: [a80ae2c98b] user: drh branch: typos, size: 29798) | |
|
2019-07-16
| ||
| 19:44 | [385ff064bc] part of check-in [9e66458592] Add new assert() statements in an attempt to help static analyzers avoid false-positives. (check-in: [9e66458592] user: drh branch: trunk, size: 29798) | |
|
2019-06-12
| ||
| 22:46 | [fd2d0553b3] part of check-in [ebb81dad1f] Adjust requirements marks and add new requirements tests. (check-in: [ebb81dad1f] user: drh branch: trunk, size: 29746) | |
|
2018-11-22
| ||
| 19:10 | [696a01f1a6] part of check-in [81629ba914] Fix a problem reading from temp databases in SQLITE_DIRECT_OVERFLOW_READ builds. (check-in: [81629ba914] user: dan branch: trunk, size: 29676) | |
|
2018-09-21
| ||
| 19:06 | [4196eb6ed3] part of check-in [7e68cdab20] Comment typo fixed. No code changes. (check-in: [7e68cdab20] user: drh branch: trunk, size: 29474) | |
|
2018-03-12
| ||
| 21:09 | [135ef0bc6f] part of check-in [0171d4a71c] Fix a typo causing SQLITE_LOG_CACHE_SPILL builds to fail. (check-in: [0171d4a71c] user: dan branch: trunk, size: 29474) | |
|
2017-10-31
| ||
| 03:40 | [7ae91a4557] part of check-in [1c80c75d4b] Remove unnecessary NEVER() and ALWAYS() conditionals. (check-in: [1c80c75d4b] user: drh branch: trunk, size: 29473) | |
|
2017-09-01
| ||
| 12:57 | [4bada07045] part of check-in [c4e7e175ee] Remove an obsolete optimization in pcache that due to more recent changes was recently making the code a little slower. (check-in: [c4e7e175ee] user: drh branch: trunk, size: 29499) | |
| 12:18 | [f79181979f] part of check-in [919863b148] 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. (check-in: [919863b148] user: drh branch: trunk, size: 29791) | |
|
2017-02-13
| ||
| 13:35 | [62835bed95] part of check-in [670f10b242] Change all legacy instances of "#if SQLITE_DEBUG" to "#ifdef SQLITE_DEBUG" for consistency. (check-in: [670f10b242] user: drh branch: trunk, size: 29901) | |
|
2016-12-13
| ||
| 18:34 | [51070ec9b8] part of check-in [dee20ba982] In the pager, avoid checking for the illegal page number 0 except when creating a new page. (check-in: [dee20ba982] user: drh branch: pager-get-method, size: 29898) | |
|
2016-12-09
| ||
| 16:02 | [219fc5238d] part of check-in [01ada3d106] Avoid unnecessary zeroing of fields in the MemPage object that are going to be reinitialized before use anyhow. A smaller and faster binary results. (check-in: [01ada3d106] user: drh branch: trunk, size: 29900) | |
|
2016-10-01
| ||
| 20:43 | [5ff2a08f76] part of check-in [34edbfd12d] Reduce the width of a memset() to avoid double-initializing some variables. (check-in: [34edbfd12d] user: drh branch: trunk, size: 29549) | |
|
2016-05-20
| ||
| 20:58 | [5583c8ade4] part of check-in [9db8f21473] Fix typo in comment. (check-in: [9db8f21473] user: mistachkin branch: trunk, size: 29515) | |
| 14:54 | [50fb5728db] part of check-in [9033afbb31] Optimizations to link list merge sort code in vdbesort.c, pcache.c, and rowset.c. Resulting binaries are 10 bytes smaller and use 0.03% fewer CPU cycles. (check-in: [9033afbb31] user: drh branch: trunk, size: 29513) | |
|
2016-05-13
| ||
| 17:22 | [f398c00843] part of check-in [b369980f0c] Improvements to a comment in the pcache.c file. No changes to code. (check-in: [b369980f0c] user: drh branch: trunk, size: 29430) | |
| 15:22 | [e93f1e1b4c] part of check-in [771c5411e9] Remove the unused PGHDR_NEED_READ flag. Add invariant checking (during SQLITE_DEBUG builds only) for the PgHdr object. (check-in: [771c5411e9] user: drh branch: trunk, size: 29040) | |
| 04:24 | [ad5ce697dc] part of check-in [32a62e3bd4] Additional debugging and tracing logic for pcache.c, turned off by default using an "#if 0". (check-in: [32a62e3bd4] user: drh branch: trunk, size: 26679) | |
|
2016-05-12
| ||
| 17:06 | [3ef140add8] part of check-in [9d55b8f541] Add extra OPTIMIZATION-IF-FALSE comments where required to pcache.c. (check-in: [9d55b8f541] user: dan branch: trunk, size: 25750) | |
| 12:08 | [5291b6ab83] part of check-in [06c1e27ca8] For in-memory databases, it does not matter if pcache entries are marked "clean" or "writable". (check-in: [06c1e27ca8] user: drh branch: trunk, size: 25509) | |
| 12:01 | [0e8453c2aa] part of check-in [0dc50d9915] Remove an unnecessary call to sqlite3PcacheMakeClean() inside of the ROLLBACK logic. (check-in: [0dc50d9915] user: drh branch: trunk, size: 25193) | |
| 09:48 | [481e549dec] part of check-in [bc202e5b41] Add a missing OPTIMIZATION-IF-FALSE comment to pcache.c. (check-in: [bc202e5b41] user: dan branch: trunk, size: 25182) | |
|
2016-05-11
| ||
| 23:54 | [132a78c71b] part of check-in [ad601c7962] For in-memory databases, it does not matter if pcache entries are marked "clean" or "writable". (check-in: [ad601c7962] user: drh branch: pager-dev, size: 25102) | |
| 20:03 | [95ee5008ed] part of check-in [3bfd2621d1] Remove a redundant condition from pcache.c. Add an OPTIMIZATION-IF-TRUE comment to another condition that requires it. (check-in: [3bfd2621d1] user: dan branch: trunk, size: 24786) | |
| 18:20 | [d7e1dd55d9] part of check-in [4533ed352d] Remove a redundant condition from pcache.c. Add an OPTIMIZATION-IF-TRUE comment to another condition that requires it. (check-in: [4533ed352d] user: dan branch: mistake, size: 24786) | |
| 15:41 | [4af980bc2a] part of check-in [9cc8cad78f] Remove some a small amount of redundant code related to PCache.pSynced from pcache.c. (check-in: [9cc8cad78f] user: dan branch: trunk, size: 24369) | |
| 10:57 | [c128cafaac] part of check-in [d9313d19c7] Add pcache tracing macros. Off by default. Requires changing an "#if 0" and recompiling to enable. (check-in: [d9313d19c7] user: drh branch: trunk, size: 23329) | |
|
2016-04-18
| ||
| 13:30 | [b3230ecfc7] part of check-in [85f3d80eb7] sqlite3PCachePerecentDirty() should return 0 if the pcache is empty. (check-in: [85f3d80eb7] user: drh branch: tempfiles-25, size: 22334) | |
|
2016-04-13
| ||
| 16:52 | [d63b34cce0] part of check-in [f6babf2920] On commit, flush dirty temp-file pages only if the file is already open and 25% or more of the cache is dirty. (check-in: [f6babf2920] user: dan branch: tempfiles-25, size: 22321) | |
|
2016-04-05
| ||
| 21:07 | [e9c00846d3] part of check-in [be5a549eba] Defer opening the file used for the temp database (where CREATE TEMP TABLE tables are stored) until the database is too large to reside entirely within the cache. There are likely still problems on this branch. (check-in: [be5a549eba] user: dan branch: tempfiles-lazy-open, size: 21959) | |
|
2016-02-13
| ||
| 23:43 | [647bb53a86] part of check-in [6a9c4a3ebf] Enhance ability to debug out-of-memory errors. (check-in: [6a9c4a3ebf] user: mistachkin branch: noMemBkpt, size: 21681) | |
|
2015-11-12
| ||
| 15:47 | [73895411fa] part of check-in [9a431362dc] Test cases. Minor problems fixed. All appears to work now. (check-in: [9a431362dc] user: drh branch: cache_spill=N, size: 21671) | |
| 14:57 | [f72f19956f] part of check-in [549d42be0d] First attempt at enhancing the "PRAGMA cache_spill" statement to accept a cache threashold size. (check-in: [549d42be0d] user: drh branch: cache_spill=N, size: 21675) | |
|
2015-09-03
| ||
| 20:43 | [24be750c79] part of check-in [f00a9e1e99] Change the pcache module to keep track of the total number of references to all pages rather than the number of pages references, for a performance improvement and size reduction. (check-in: [f00a9e1e99] user: drh branch: trunk, size: 20971) | |
|
2015-06-30
| ||
| 03:57 | [cde06aa509] part of check-in [d9a0481ce0] Optimization to the sqlite3PcacheFetch() logic. (check-in: [d9a0481ce0] user: drh branch: trunk, size: 20846) | |
|
2015-06-29
| ||
| 18:29 | [379fd77feb] part of check-in [7c4ef7b7c8] 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. (check-in: [7c4ef7b7c8] user: drh branch: trunk, size: 20850) | |
| 04:21 | [994f15b465] part of check-in [8619fc346d] 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. (check-in: [8619fc346d] user: drh branch: trunk, size: 20834) | |
|
2015-06-26
| ||
| 02:41 | [d8b1963270] part of check-in [015302f15e] Simplify the pcache by not keeping continuous track of page 1 but instead just loading page 1 on the rare occasions when it is actually needed. (check-in: [015302f15e] user: drh branch: trunk, size: 20593) | |
|
2015-02-27
| ||
| 21:53 | [10539fb959] part of check-in [766ad65025] Remove all references to SQLITE_DEFAULT_TEMP_CACHE_SIZE. Add requirements marks related to cache_size changing. (check-in: [766ad65025] user: drh branch: trunk, size: 20605) | |
|
2015-01-09
| ||
| 19:45 | [d210cf90d0] part of check-in [88a7a96711] Remove an unused preprocessor macro from pcache.c. (check-in: [88a7a96711] user: drh branch: trunk, size: 20214) | |
|
2014-12-30
| ||
| 13:04 | [b83d160ce8] part of check-in [340b347758] Make SQLITE_CONFIG_PCACHE_HDRSZ accurate (not an over-estimate) on 32-bit systems. (check-in: [340b347758] user: drh branch: trunk, size: 20590) | |
| 00:57 | [8ee2ce15c4] part of check-in [b28ce75f2d] Round all object sizes that go into computing SQLITE_CONFIG_PCACHE_HDRSZ up to a multiple of 8 bytes. (check-in: [b28ce75f2d] user: drh branch: trunk, size: 20566) | |
|
2014-11-04
| ||
| 12:11 | [ace1b67632] part of check-in [6eb03e62a3] Add the SQLITE_CONFIG_PCACHE_HDRSZ option for sqlite3_config(). (check-in: [6eb03e62a3] user: drh branch: trunk, size: 20558) | |
|
2014-09-15
| ||
| 14:59 | [4121a0571c] part of check-in [69a6456077] Remove the EXPENSIVE_ASSERTS in pcache.c having to do with the pSynced field of the Pcache object, as they are incorrect, as revealed by recent pcache enhancements. (check-in: [69a6456077] user: drh branch: trunk, size: 20395) | |
|
2014-09-12
| ||
| 20:30 | [b42c513da2] part of check-in [b332a84d51] Small performance improvement to the dirty list handling in the pager. (check-in: [b332a84d51] user: drh branch: trunk, size: 21159) | |
|
2014-09-06
| ||
| 16:39 | [2048affdb0] part of check-in [e62aab5e92] Fix typos in comments. No code changes. (check-in: [e62aab5e92] user: peter.d.reid branch: trunk, size: 21149) | |
|
2014-08-27
| ||
| 23:18 | [3b3791297e] part of check-in [bdb6e4978d] Refactor the sqlite3PcacheFetch() routine into three separate routines, which are significantly faster overall and about 100 bytes smaller in size as well. (check-in: [bdb6e4978d] user: drh branch: trunk, size: 21147) | |
|
2014-08-26
| ||
| 15:06 | [c216e40774] part of check-in [f1f94a971e] 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. (check-in: [f1f94a971e] user: drh branch: trunk, size: 18378) | |
|
2014-08-22
| ||
| 20:35 | [da602c5447] part of check-in [6bcf1af6a4] Combine the pcacheAddToDirtyList() and pcacheRemoveFromDirtyList() routines into a single pcacheManageDirtyList() routine. The resulting binary code is slightly faster and a few bytes smaller. (check-in: [6bcf1af6a4] user: drh branch: trunk, size: 18401) | |
|
2014-02-03
| ||
| 17:04 | [d8eafac282] part of check-in [b60cc11ef7] Performance optimizations in sqlite3PcacheFetch(). (check-in: [b60cc11ef7] user: drh branch: trunk, size: 17855) | |
|
2012-01-02
| ||
| 15:45 | [f8043b433a] part of check-in [17c30634a7] Make sure large negative arguments to PRAGMA cache_size do not cause 32-bit signed integer overflow. Also correct a requirements mark. (check-in: [17c30634a7] user: drh branch: trunk, size: 17142) | |
|
2011-11-16
| ||
| 19:29 | [1fdd77978c] part of check-in [3f58e7c889] Add the sqlite3_db_release_memory() interface and the shrink_memory pragma. (check-in: [3f58e7c889] user: drh branch: trunk, size: 17130) | |
|
2011-11-14
| ||
| 12:34 | [e9246c2074] part of check-in [638a39bbaa] Further work on mmap(). Still does not work right - autovacuum tests are the first to fail. (check-in: [638a39bbaa] user: drh branch: mmap-experimental, size: 16949) | |
| 01:55 | [ccbd5b1280] part of check-in [09be42d5fa] Begin making experimental changes to use mmap() for reading content from a database. The code compiles, but crashes on the test suite. (check-in: [09be42d5fa] user: drh branch: mmap-experimental, size: 16949) | |
|
2011-11-09
| ||
| 14:23 | [b9d52e9f84] part of check-in [b3faa680ae] A negative value N for the cache_size pragma adjusts the number of cache pages to use approximately N kibibytes of memory. (check-in: [b3faa680ae] user: drh branch: experimental-pcache, size: 16935) | |
| 00:06 | [8820564f6e] part of check-in [4da7095683] Update the API documentation for the new pcache2 interface. Change the order of parameters on the xCreate method of pcache2. (check-in: [4da7095683] user: drh branch: experimental-pcache, size: 16609) | |
|
2011-11-08
| ||
| 20:08 | [fad8646667] part of check-in [c275c9d323] Experimental change to the pcache interface to allow page buffers to be allocated separately from their associated container structures. (check-in: [c275c9d323] user: dan branch: experimental-pcache, size: 16609) | |
|
2011-05-28
| ||
| 15:53 | [49e718c095] part of check-in [5f15579f8c] Print a log message on each cache spill if compiled with SQLITE_LOG_CACHE_SPILL. (check-in: [5f15579f8c] user: drh branch: trunk, size: 16540) | |
|
2010-09-09
| ||
| 18:25 | [09d38c44ab] part of check-in [34edb54bb0] Further updates to the sqlite3_pcache_methods documentation, plus the addition of a few evidence marks related to pcache. (check-in: [34edb54bb0] user: drh branch: trunk, size: 16256) | |
|
2010-06-10
| ||
| 06:53 | [1e9aa2dbc0] part of check-in [0ce42e7665] Store the MemPage structure in memory following, instead of preceding, the page data for cached pages. This reduces the likelihood of a corrupt database page image causing SQLite to read past the end of a buffer. (check-in: [0ce42e7665] user: dan branch: trunk, size: 15997) | |
|
2010-03-19
| ||
| 19:23 | [ace8f6a5ec] part of check-in [88810cd091] Put an ALWAYS() around a condition in pcache.c that must always be true in the current implementation. (check-in: [88810cd091] user: drh branch: trunk, size: 15902) | |
|
2010-03-02
| ||
| 23:34 | [4956b41d6b] part of check-in [9daf4e7d07] When TEMP files are in memory, also put the massive TEMP file used by the VACUUM command in memory. (check-in: [9daf4e7d07] user: drh branch: trunk, size: 15682) | |
|
2010-02-04
| ||
| 17:38 | [815bcb3cf0] part of check-in [26cb1df735] Fix a performance glitch that appears for large transactions. (check-in: [26cb1df735] user: drh branch: trunk, size: 15658) | |
|
2009-11-10
| ||
| 01:30 | [3b07930637] part of check-in [f6c045f649] Remove the obsolete "$Id:$" RCS identifier strings from the source code. (check-in: [f6c045f649] user: drh branch: trunk, size: 15631) | |
|
2009-07-25
| ||
| 11:46 | [c92ffd4f3e] part of check-in [64c7afc704] Add files that should have gone in with the previous checkin. (CVS 6935) (check-in: [64c7afc704] user: danielk1977 branch: trunk, size: 15701) | |
|
2009-07-21
| ||
| 19:25 | [1dae135b70] part of check-in [0b41dfc066] Change getAndInitPage() (btree.c) to use only PagerAcquire(), not PagerLookup() and PagerAcquire(). (CVS 6916) (check-in: [0b41dfc066] user: danielk1977 branch: trunk, size: 15670) | |
|
2009-07-16
| ||
| 18:21 | [7d27635a4b] part of check-in [9452517981] Code simplifications and comment improvements in support of structural coverage testing. (CVS 6899) (check-in: [9452517981] user: drh branch: trunk, size: 15659) | |
|
2009-03-31
| ||
| 01:32 | [395f752a13] part of check-in [d5cab05c9e] Remove two unused lines from pcache.c. (CVS 6415) (check-in: [d5cab05c9e] user: drh branch: trunk, size: 15734) | |
|
2009-01-23
| ||
| 16:45 | [fcf7738c83] part of check-in [9c0b9f8813] Optimization: When loading a new page into the cache, avoid redundant memset() calls to zero it. (CVS 6201) (check-in: [9c0b9f8813] user: danielk1977 branch: trunk, size: 15784) | |
|
2009-01-20
| ||
| 17:06 | [48fbfc2208] part of check-in [12f7346c13] Big change to make pager.c easier to follow. Unused variables removed, comments improved, etc. (CVS 6197) (check-in: [12f7346c13] user: danielk1977 branch: trunk, size: 15557) | |
|
2009-01-16
| ||
| 16:23 | [a3c729f4bb] part of check-in [a353c1ab37] Revert (6187). (CVS 6188) (check-in: [a353c1ab37] user: danielk1977 branch: trunk, size: 15619) | |
| 15:21 | [922872b215] part of check-in [aa67fd0cdb] This commit is an error. Reverted by (6188). (CVS 6187) (check-in: [aa67fd0cdb] user: danielk1977 branch: trunk, size: 15600) | |
|
2008-12-04
| ||
| 20:40 | [16dc8da6e6] part of check-in [39a0750b49] Replace the VDBE Fifo object with the new RowSet object. (CVS 5977) (check-in: [39a0750b49] user: drh branch: trunk, size: 15611) | |
|
2008-11-19
| ||
| 16:52 | [f3121a5317] part of check-in [d1abe8a1c9] Fix some compiler warnings that show up when building the amalgamation only. (CVS 5927) (check-in: [d1abe8a1c9] user: danielk1977 branch: trunk, size: 15620) | |
|
2008-11-13
| ||
| 14:28 | [439bcf164f] part of check-in [47866d6708] Add an API to support custom page cache implementations. (CVS 5899) (check-in: [47866d6708] user: danielk1977 branch: trunk, size: 15594) | |
|
2008-11-11
| ||
| 18:43 | [3d547c3921] part of check-in [9d880a6fd2] Remove some asserts that refer to variables removed in (5830). (CVS 5884) (check-in: [9d880a6fd2] user: danielk1977 branch: trunk, size: 33870) | |
| 00:36 | [81ded33684] part of check-in [89ee5295bd] When an assignment occurs in a boolean, always test the result using "!=0" to avoid confusion and make it clear that assignment is intended, not an equality test. Ticket #3491. (CVS 5879) (check-in: [89ee5295bd] user: drh branch: trunk, size: 33920) | |
|
2008-10-17
| ||
| 18:51 | [5b80676e66] part of check-in [39ebf01add] 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) (check-in: [39ebf01add] user: danielk1977 branch: trunk, size: 33909) | |
|
2008-09-29
| ||
| 11:49 | [f8d7beceba] part of check-in [40425e9342] 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) (check-in: [40425e9342] user: danielk1977 branch: trunk, size: 36032) | |
|
2008-09-24
| ||
| 09:12 | [52108517c3] part of check-in [0fb98c3535] Fix some function declarations (change "int foo()" to "int foo(void)"). Ticket #3399. (CVS 5740) (check-in: [0fb98c3535] user: danielk1977 branch: trunk, size: 36198) | |
|
2008-09-21
| ||
| 15:14 | [e2a4dd0ae4] part of check-in [6521f98ac3] Give file scope to non-API routines in pcache. Ticket #3392. (CVS 5727) (check-in: [6521f98ac3] user: drh branch: trunk, size: 36182) | |
|
2008-09-18
| ||
| 17:34 | [e025e5380d] part of check-in [6b998f3066] Avoid parsing the structure of b-tree pages (in sqlite3BtreeInitPage) more than is necessary. (CVS 5720) (check-in: [6b998f3066] user: danielk1977 branch: trunk, size: 36162) | |
|
2008-09-17
| ||
| 20:06 | [c799d753a5] part of check-in [a7fd9e622b] 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) (check-in: [a7fd9e622b] user: drh branch: trunk, size: 35936) | |
| 11:02 | [a39908e73c] part of check-in [94fde77b9a] Add a type identifier to argument sz to sqlite3PageMalloc() in pcache.c. Ticket #3383. (CVS 5713) (check-in: [94fde77b9a] user: danielk1977 branch: trunk, size: 35845) | |
|
2008-09-15
| ||
| 15:36 | [d3c0f4ad70] part of check-in [3bc221b940] Adjust the page recycling algorithm so that the number of pages allocated to each connection does not exceed its cache_size limit. (CVS 5701) (check-in: [3bc221b940] user: drh branch: trunk, size: 35833) | |
|
2008-09-02
| ||
| 09:38 | [ff79cb5eb7] part of check-in [44def90d1b] Modify pcache.c to work with OMIT_WSD. (CVS 5659) (check-in: [44def90d1b] user: danielk1977 branch: trunk, size: 35675) | |
|
2008-09-01
| ||
| 18:34 | [200de27e85] part of check-in [573d92abb9] Begin adding support for the SQLITE_OMIT_WSD macro. Some (many) WSD variables still need wrappers added to them. (CVS 5652) (check-in: [573d92abb9] user: danielk1977 branch: trunk, size: 35250) | |
|
2008-08-29
| ||
| 09:10 | [e1cb0e77d2] part of check-in [4b12922dcb] 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) (check-in: [4b12922dcb] user: danielk1977 branch: trunk, size: 35244) | |
|
2008-08-28
| ||
| 17:46 | [4853068cb2] part of check-in [44193b9277] Partial fix for a bug in recovery from xStress failures in pcache. (CVS 5635) (check-in: [44193b9277] user: drh branch: trunk, size: 34299) | |
| 11:12 | [c45e2440b8] part of check-in [5e304fed27] Fix mutex related bug in pcache.c to do with handling IO errors. (CVS 5632) (check-in: [5e304fed27] user: danielk1977 branch: trunk, size: 34288) | |
| 10:21 | [23dba1a9f2] part of check-in [473c09fac2] Enable the disabled asserts added by (5629). Add extra tests to thread003.test. And the required modifications to pcache.c. (CVS 5631) (check-in: [473c09fac2] user: danielk1977 branch: trunk, size: 34288) | |
| 08:31 | [8a2d92fb12] part of check-in [1928f15b78] Fix a threads/mutex problem in pcache.c. (CVS 5630) (check-in: [1928f15b78] user: danielk1977 branch: trunk, size: 34312) | |
| 02:26 | [aa609c9b1f] part of check-in [da1777259f] Miscellaneous cleanup in the new pcache code. (CVS 5629) (check-in: [da1777259f] user: drh branch: trunk, size: 34293) | |
|
2008-08-27
| ||
| 16:38 | [3d9d933bb2] part of check-in [b01c65b065] Modifications to malloc5.test to account for the fact that sqlite3_release_memory() no longer reclaims dirty pages. (CVS 5625) (check-in: [b01c65b065] user: danielk1977 branch: trunk, size: 32639) | |
| 15:16 | [94050f6801] part of check-in [9e9325997e] Use a bitvec object to store the set of pages with the 'always-rollback' property for a transaction. (CVS 5622) (check-in: [9e9325997e] user: danielk1977 branch: trunk, size: 32617) | |
| 09:44 | [9e00544dd8] part of check-in [7de32498b3] Remove unreachable branches from pcache.c. (CVS 5620) (check-in: [7de32498b3] user: danielk1977 branch: trunk, size: 32924) | |
|
2008-08-26
| ||
| 19:08 | [006714ad89] part of check-in [555dad900f] Disable some very expensive asserts in pcache.c that are too slow for all.test. (CVS 5616) (check-in: [555dad900f] user: danielk1977 branch: trunk, size: 32705) | |
| 18:05 | [03c2ad23aa] part of check-in [9e511e161b] 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) (check-in: [9e511e161b] user: danielk1977 branch: trunk, size: 32628) | |
|
2008-08-25
| ||
| 14:49 | [4883f37145] part of check-in [e3840fbf0a] Pick up a small performance increase by eliminating the pcacheRef() function. (CVS 5609) (check-in: [e3840fbf0a] user: danielk1977 branch: trunk, size: 33756) | |
| 07:12 | [67c402c23d] part of check-in [16f612d61e] If the sector size is greater than the database page size, SQLite journals all pages that lie within a sector before writing to any of them. This change ensure that a journal sync does not occur halfway through journalling the set of pages that belong to a single sector. (CVS 5605) (check-in: [16f612d61e] user: danielk1977 branch: trunk, size: 34302) | |
|
2008-08-23
| ||
| 18:53 | [4858bf42f9] part of check-in [a323bd29a6] Instead of marking a page as clean when sqlite3PagerDontWrite() is called, set a dedictated flag - PGHDR_DONT_WRITE. (CVS 5604) (check-in: [a323bd29a6] user: danielk1977 branch: trunk, size: 33921) | |
|
2008-08-22
| ||
| 17:34 | [3feb47f5ce] part of check-in [6de9c084fc] Remove dead code. (CVS 5601) (check-in: [6de9c084fc] user: drh branch: trunk, size: 33880) | |
| 17:09 | [504e620412] part of check-in [8fe234b2ca] Relinquish the pcache mutex before calling an xStress callback. This ensures that the pcache mutex is never held while IO is performed. (CVS 5599) (check-in: [8fe234b2ca] user: danielk1977 branch: trunk, size: 33841) | |
| 16:22 | [e12359db29] part of check-in [93dbc5427b] 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) (check-in: [93dbc5427b] user: danielk1977 branch: trunk, size: 34431) | |
|
2008-08-21
| ||
| 20:21 | [f57227003d] part of check-in [80d6a31cb3] Move date+time functions to start-time initialization. Additional start-time function cleanup. (CVS 5585) (check-in: [80d6a31cb3] user: drh branch: trunk, size: 33784) | |
| 15:54 | [4668410008] part of check-in [2091d9a526] Fix soft-heap-limit related test suite failures. (CVS 5582) (check-in: [2091d9a526] user: danielk1977 branch: trunk, size: 33793) | |
| 12:32 | [54d03c3550] part of check-in [a2f375fffb] Patch to mkfunction to try and detect miscompiles. Add an unimportant assert back to pcache.c. (CVS 5577) (check-in: [a2f375fffb] user: drh branch: trunk, size: 32923) | |
| 12:19 | [614f927e2e] part of check-in [d025866b09] 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) (check-in: [d025866b09] user: danielk1977 branch: trunk, size: 32871) | |
| 04:41 | [e244ef4b70] part of check-in [899fa19d1a] Move an assert() in sqlite3PcacheDirtyPage() so that it does not occur before local variable declarations. Ticket #3325. (CVS 5575) (check-in: [899fa19d1a] user: danielk1977 branch: trunk, size: 31546) | |
|
2008-08-20
| ||
| 21:47 | [cf7a7c8136] part of check-in [4b0e67d397] Comment and function naming tweaks to pcache. No functionality changes. (CVS 5572) (check-in: [4b0e67d397] user: drh branch: trunk, size: 31538) | |
| 14:49 | Added: [c1a9abb5e2] part of check-in [cb494e10d7] 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) (check-in: [cb494e10d7] user: danielk1977 branch: trunk, size: 31157) | |