SQLite
Timeline
Not logged in

50 most recent timeline items

2015-07-04
18:44
[8cf02090] Leaf: Optimize seek operations on fts5 b-trees. (user: dan, tags: trunk)
18:15
[dacb2a61] Preserve the number of requested PAGECACHE pages even if the memory pointer or size is zero. Enhance the pcache1.c header comment to explain the memory layout of a page cache line. (user: drh, tags: trunk)
15:35
[4e473559] Fix a problem in the fts5 integrity-check. (user: dan, tags: trunk)
11:14
[743bf1f1] Do not preserve the btreeInitPage() results in PRAGMA integrity_check if there were cell sizing errors because PRAGMA cell_size_check was turned off during the btreeInitPage() call. (user: drh, tags: trunk)
00:04
[43ead44e] Sync up Makefile clean targets for FTS5. (user: mistachkin, tags: trunk)
2015-07-03
23:29
[4e515897] Correction to check-in [1025873fdf], tighten up the number of static test mutexes. (user: mistachkin, tags: trunk)
23:12
[e6c03e72] Update clean target in MSVC makefile. (user: mistachkin, tags: trunk)
23:11
[1025873f] Enhance mutex testing to include APP and VFS static mutexes. (user: mistachkin, tags: trunk)
21:38
[b202e2a1] Add static mutexes for use by the built-in / third-party VFSs and use the built-in VFS mutex where appropriate. (user: mistachkin, tags: trunk)
20:47
[0778825d] Rework the Fts5MultiSegIter structure a bit to make it more efficient. (user: dan, tags: trunk)
19:13
[3df4af5d] Speed up eof checks on fts5 cursors. (user: dan, tags: trunk)
17:54
[030f60a7] Enable use of the __builtin_bswap32() only with GCC 4.3 and higher. (user: mistachkin, tags: trunk)
17:14
[b9b0c1e5] Avoid freeing the array of instance matches each time the fts5 xNext() method is called. (user: dan, tags: trunk)
14:34
[2b756722] New command-line options for speedtest1: --multithread, --nomemstat, --serialized, and --singlethread (user: drh, tags: trunk)
2015-07-02
20:12
[4d8f03dc] Copy fts5.h into the build directory as part of building fts5.c. Also remove code to edit fts5parse.c from various Makefiles and add it to mkfts5c.tcl. (user: dan, tags: trunk)
19:47
[e53d497c] When doing coverage analysis of a btree page for pragma integrity_check, make the first entry (that covers the header, cell index, and gap) implied, for a performance boost and size reduction. (user: drh, tags: trunk)
18:52
[edbcccd3] Minor change to mkfts5c.tcl so that fts5.c can be used according to the instructions in loadext.html. (user: dan, tags: trunk)
18:47
[85ca4409] Leaf: Merge in the latest enhancements from trunks, especially the use of _byteswap_ulong() and similar intrinsics on MSVC. (user: drh, tags: sessions)
18:16
[ec257348] Add fts5_source_id() SQL function, similar to sqlite_source_id(). (user: dan, tags: trunk)
16:52
[bcc8a755] Fix harmless compiler warnings and one macro VVA_ONLY macro usage issue. (user: mistachkin, tags: trunk)
16:50
[f022e043] Simplify FTS5 handling in the MSVC makefile. (user: mistachkin, tags: trunk)
16:29
[3a26a919] Fix a (harmless) shadowed local variable definition in the integrity_check logic. (user: drh, tags: trunk)
16:17
[251a7590] Smaller and faster PRAGMA integrity_check that also does a better job of detecting errors. Some output text describing discovered file corruption has changed for clarity. (user: drh, tags: trunk)
15:52
[7819002e] Remove "#ifdef SQLITE_ENABLE_FTS5" from individual fts5 source files. Add a single "#if !defined(SQLITE_CORE) || defined(SQLITE_ENABLE_FTS5)" to fts5.c. (user: dan, tags: trunk)
01:38
[c9ddbd88] Add the --shrink-memory option to the speedtest1 test program. (user: drh, tags: trunk)
2015-07-01
19:59
[2a897b9e] Avoid create a stack from in sqlite3BackupUpdate() in the common case where the first argument is NULL. (user: drh, tags: trunk)
17:54 • Edit [1c52212369692ca7|1c522123]: Marked "Closed". (user: drh)
17:53
[550705fc] Simplification of PRAGMA integrity_check logic. Make sure that the depth of the right-most subtree is correct. Size reduction and performance increase, with no change in output. (user: drh, tags: trunk)
17:13
[1c522123] Closed-Leaf: Rework the PRAGMA integrity_check logic. Simplify the checkTreePage() routine and clean up the error messages generated. (user: drh, tags: integrity-check-refactor)
04:08
[307195c8] Fix some harmless compiler warnings. (user: drh, tags: trunk)
01:31
[59ad912c] Change integrity_check to analyze the cells of a page in reverse order, as this will tend to insert the cells into the analysis heap in increasing order by address, which is the most efficient way to load a min-heap. (user: drh, tags: trunk)
2015-06-30
17:28
[fe144dd7] Make use of the _byteswap_ushort() and _byteswap_ulong() compiler intrinsics for MSVC, when available. (user: mistachkin, tags: trunk)
16:29
[39936b33] Merge all the latest enhancements from trunk. This merge include FTS5 and a number of notable performance enhancements. (user: drh, tags: sessions)
15:10
[8bfcda3d] Make use of built-in bswap32() and bswap16() functions in GCC/Clang for a significant performance improvement there. (user: drh, tags: trunk)
14:01
[ce8177e3] Closed-Leaf: Only use __builtin_bswap16() with GCC 4.8 and later. (user: drh, tags: bswap-functions)
13:36 • Edit [bc27ebd7f73e9fc8|bc27ebd7]: Move to branch bswap-functions... (user: drh)
13:28
[79ff36b7] Remove the use of htonl() in the previous check-in due to linkage issues. Add the get2byteAligned() macro and use it for access to the cell offsets on btree pages for about a 1% performance gain. (user: drh, tags: bswap-functions)
12:47
[bc27ebd7] Make use of htonl() and __builtin_bswap32() for faster implementations of sqlite3Get4byte() and sqlite3Put4byte(). (user: drh, tags: bswap-functions)
11:07
[b406b20e] Change an unreachable branch into an assert() in sqlite3PagerAcquire() and optimize sqlite3PcacheOpenSavepoint() by factoring out rarely used code into a subroutine. (user: drh, tags: trunk)
03:57
[d9a0481c] Optimization to the sqlite3PcacheFetch() logic. (user: drh, tags: trunk)
03:34
[a0fa6b3b] Put all variable declarations for sqlite3PagerWrite() at the beginning of the block. Syntax only - no logic changes. (user: drh, tags: trunk)
03:18
[8001aa52] Implement sqlite3Strlen30() using strlen() from the C library. (user: drh, tags: trunk)
03:13
[791b706e] Change sqlite3ApiExit() so that its first argument is never NULL. (user: drh, tags: trunk)
02:47
[429ccef2] Put BtCursor objects on a singly-linked list instead of a doubly-linked list. Add the BTCF_Multiple flag. Only invoke saveAllCursors() when using a cursor that has BTCF_Multiple set. (user: drh, tags: trunk)
01:25
[ed54c14e] Convert several 5-year-old and older NEVER() macros into assert(). (user: drh, tags: trunk)
2015-06-29
23:01
[53fe685d] From sqlite3BtreeInsert(), bypass the btreeMoveto() routine for table inserts and go directly to sqlite3BtreeMovetoUnpacked(). (user: drh, tags: trunk)
20:53
[ba425a6a] Add a bypass path in sqlite3PagerWrite() for pages with the PGHDR_WRITEABLE bit set, for about a 1% performance increase. (user: drh, tags: trunk)
19:08
[3b65eb56] Combine subjRequiresPage() and subjournalPage() into a single subjournalPageIfRequired() routine. (user: drh, tags: trunk)
18:29
[7c4ef7b7] 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. (user: drh, tags: trunk)
18:14
[14de3d39] Fix over-length source code lines in pager.c. (user: drh, tags: trunk)