SQLite
Timeline
Not logged in

50 most recent check-ins

2015-06-30
17:28
[fe144dd7] Leaf: Make use of the _byteswap_ushort() and _byteswap_ulong() compiler intrinsics for MSVC, when available. (user: mistachkin, tags: trunk)
16:29
[39936b33] Leaf: 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: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)
15:41
[6aaaec6e] Fix minor problems in the ota demo application. (user: dan, tags: trunk)
14:11
[ab7aeeea] Simplifications and performance improvement in pager_write(). (user: drh, tags: trunk)
04:21
[8619fc34] 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. (user: drh, tags: trunk)
03:28
[9b3a7281] Very small size reduction and performance increase in sqlite3BitvecTest(). (user: drh, tags: trunk)
00:52
[18115164] Move an assert() and testcase() into their correct position within getAndInitPage(). (user: drh, tags: trunk)
00:21
[fde70472] Use tail recursion in pcache1Unpin() to get a small size reduction and speed improvement. (user: drh, tags: trunk)
2015-06-28
17:33
[94ef1701] Comment typo fix and minor cleanup in the pager. No logic changes. (user: drh, tags: trunk)
02:58
[9cd30d33] Avoid unnecessary calls to sqlite3VdbeSerialTypeLen() for integer serial types, for a small size reduction and a speed increase. (user: drh, tags: trunk)
2015-06-27
23:55
[63998471] Make greater use of BtCursor.curIntKey. (user: drh, tags: trunk)
22:49
[4a17df13] Add the BtCursor.curIntKey field and use it for a small size reduction and performance boost. (user: drh, tags: trunk)
20:55
[291d9e0c] Enhancements to the previous check-in to make it a little smaller and faster. (user: drh, tags: trunk)
19:45
[1956a4ce] Performance improvements in moveToChild() by shifting some work over to getAndInitPage(). Net improvement is about 800K cycles at cost of 30 bytes. (user: drh, tags: trunk)
15:51
[7f65b96b] Manually inline the call from getAndInitPage() to btreeGetPage() for a savings of 2.5 million cycles at a cost of less than 100 bytes. (user: drh, tags: trunk)
14:59
[9383a688] Add releasePageNotNull() as an alternative to releasePage() when the argument is guaranteed to be non-NULL, and use it for a small performance gain. (user: drh, tags: trunk)
03:58
[bee94dc3] Add the Mempage.aDataOfst field and use it in sqlite3BtreeMovetoUnpacked() for about a 2 million cycle gain. (user: drh, tags: trunk)
2015-06-26
20:45
[7c610276] Treat compilation of FTS5 for the loadable extension specially with MSVC. (user: mistachkin, tags: trunk)
20:25
[d27d9965] Merge fts5 branch into trunk. (user: dan, tags: trunk)
20:14
[8671b9e1] Leaf: Merge latest trunk with this branch. (user: dan, tags: fts5)
20:13
[c1b268ce] Remove unnecessary lines from fts3.h and main.mk. (user: dan, tags: fts5)
20:08
[713239b8] Fix a segfault that could follow an OOM error in fts5. (user: dan, tags: fts5)
19:43
[b6bedc2e] Small size reduction and performance increase on the OP_IdxInsert opcode. (user: drh, tags: trunk)
19:33
[2a1af0f2] Merge latest trunk changes with this branch. (user: dan, tags: fts5)
18:50
[360c57bb] Fix some cases in the fts5 code where a corrupt database could cause a buffer overread. (user: dan, tags: fts5)
18:47
[eaddbf29] Further optimization of SQL function dispatch. Improvements to opcode documentation. (user: drh, tags: trunk)
18:16
[2abc44eb] Cache the sqlite3_context structure in the P4 operand of VDBE programs for faster SQL function dispatch. (user: drh, tags: trunk)
17:10
[954231d2] Merge changes to get FTS5 working with MSVC. (user: mistachkin, tags: fts5)
16:55
[bfcd1608] Closed-Leaf: Merge upstream changes. Get the test fixture working with FTS5. Fix compiler warnings. (user: mistachkin, tags: fts5Msvc)
16:42
[c91a93b3] Remove fts5 initialization code from core file main.c. (user: dan, tags: fts5)
16:17
[be85b824] Add FTS5 DLL target for MSVC. (user: mistachkin, tags: fts5Msvc)
13:31
[2f31bdd1] Closed-Leaf: Cache the most recently sqlite3_context used by OP_Function and reuse it on subsequent calls, if appropriate. This gives a noticable performance boost. (user: drh, tags: function-ctx-cache)
04:34
[ef2052f8] Initial changes to get FTS5 working with MSVC. (user: mistachkin, tags: fts5Msvc)
03:12
[7097716c] Fix harmless compiler warning in assert statement. (user: mistachkin, tags: trunk)