/ Timeline
Login

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

100 ancestors of [862418e3]

2015-07-15
19:46
Use a WITHOUT ROWID table to index fts5 btree leaves. This is faster to query and only slightly larger than storing btree nodes within an intkey table. check-in: 862418e3 user: dan tags: fts5-btree-index
18:35
Fix some harmless compiler warnings. check-in: 110cd84f user: drh tags: trunk
18:04
Attempt to fix harmless warnings generated by GCC and Clang runtime analyzers. check-in: b522c95d user: drh tags: trunk
13:56
Fix the fuzz3.test script so that it works with the new bulk pagecache allocation feature. check-in: 829a2dba user: drh tags: trunk
2015-07-14
22:43
Amplify the comment on renderLogMsg() that explains the problems associated with calling sqlite3_log() from deep within the memory allocator. check-in: a73d7128 user: drh tags: trunk
21:56
Further refine FTS5 cleanup in Makefiles. check-in: b53a9506 user: mistachkin tags: trunk
21:56
Skip trying to include 'intrin.h' when compiling for WinCE with MSVC. check-in: 6db90ca2 user: mistachkin tags: trunk
17:18
Fix some harmless compiler warnings. check-in: 3de030c9 user: mistachkin tags: trunk
14:48
Always invoke the profile callback even if the statement does not run to completion. check-in: 202479aa user: drh tags: trunk
00:36
Refine cleaning of FTS5 files by Makefile targets. check-in: e548d77b user: mistachkin tags: trunk
2015-07-13
23:55
Fix the origination date on the loadfts.c utility program. check-in: 5c76c062 user: drh tags: trunk
18:01
Fix the header comment on the loadfts.c utility program. check-in: 955ad4ae user: drh tags: trunk
2015-07-10
17:55
Fix inconsistencies in formatting of fts5 docs. check-in: 5fb4c771 user: dan tags: trunk
2015-07-09
20:46
Improve the performance of docid merges in fts5. check-in: b2de77a0 user: dan tags: trunk
19:02
Reduce the number of calls to malloc() made by fts5. check-in: 898618cc user: dan tags: trunk
2015-07-08
17:59
Fix two problems that could cause fts3 auxiliary functions to occasionally misbehave if used with match expressions that contain both OR and NEAR. check-in: 372c1db2 user: dan tags: trunk
16:22
Enhance the pcache1 page cache so that it tries to allocate a block of SQLITE_DEFAULT_PCACHE_INITSZ pages from malloc() on startup, and uses those preallocated pages when possible rather than going to malloc() for each individual page. About a 5% performance increase for some workloads. check-in: 5348ffc3 user: drh tags: trunk
14:13
Comment fix. No changes to code. Closed-Leaf check-in: c1e2ed0e user: drh tags: pcache-bulk-local
13:40
Do not do the bulk pcache1 allocations if SQLITE_CONFIG_PAGECACHE specifies a global page cache buffer. check-in: 75d98dae user: drh tags: pcache-bulk-local
12:25
Early detection of file corruption in a debugging routine, before the invalid data can cause problems. check-in: b27a47fe user: drh tags: trunk
01:22
Avoid left-shifting bits into the sign of a signed integer, as such behavior is technically undefined. check-in: 9417b402 user: drh tags: pcache-bulk-local
2015-07-07
21:14
Add a compile-time constant for configuring the default pagecache setup. check-in: ad5fdfba user: drh tags: pcache-bulk-local
19:35
Merge the Fts5MultiSegIter and Fts5IndexIter objects. check-in: 6ace7354 user: dan tags: trunk
19:07
Add a test case to verify that "PRAGMA data_version" works as expected when an OTA client writes to the database. check-in: 6441f2dc user: dan tags: trunk
15:14
No need to test sqlite3GlobalConfig.bCoreMutex when SQLITE_THREADSAFE==0. check-in: 26db0fee user: drh tags: pcache-bulk-local
14:06
Simplify the page recycling condition in pcache1. Fix test cases to work with the latest changes. check-in: 5b60df55 user: drh tags: pcache-bulk-local
08:29
Further optimizations for fts5 b-tree seeks. check-in: f3789968 user: dan tags: trunk
2015-07-06
20:57
A unified cache is now only used for SQLITE_ENABLE_MEMORY_MANAGEMENT, or if SQLITE_CONFIG_PAGECACHE defines a shared start-time page cache buffer and the application is single-threaded. check-in: d5ff1d69 user: drh tags: pcache-bulk-local
20:27
Speed up seek operations on fts5 b-tree structures. check-in: 7b7da1eb user: dan tags: trunk
18:54
Enhance separate pcache1 to allocate a block of pages from heap on startup, if possible, for a 5.2% performance improvement. check-in: aa7341c8 user: drh tags: pcache-bulk-local
2015-07-05
22:15
Do not allow recursive CTEs that use aggregate queries in the recursive part. check-in: 6d2999af user: drh tags: trunk
2015-07-04
18:44
Optimize seek operations on fts5 b-trees. check-in: 8cf02090 user: dan tags: trunk
18:15
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. check-in: dacb2a61 user: drh tags: trunk
15:35
Fix a problem in the fts5 integrity-check. check-in: 4e473559 user: dan tags: trunk
11:14
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. check-in: 743bf1f1 user: drh tags: trunk
00:04
Sync up Makefile clean targets for FTS5. check-in: 43ead44e user: mistachkin tags: trunk
2015-07-03
23:29
Correction to check-in [1025873fdf], tighten up the number of static test mutexes. check-in: 4e515897 user: mistachkin tags: trunk
23:12
Update clean target in MSVC makefile. check-in: e6c03e72 user: mistachkin tags: trunk
23:11
Enhance mutex testing to include APP and VFS static mutexes. check-in: 1025873f user: mistachkin tags: trunk
21:38
Add static mutexes for use by the built-in / third-party VFSs and use the built-in VFS mutex where appropriate. check-in: b202e2a1 user: mistachkin tags: trunk
20:47
Rework the Fts5MultiSegIter structure a bit to make it more efficient. check-in: 0778825d user: dan tags: trunk
19:13
Speed up eof checks on fts5 cursors. check-in: 3df4af5d user: dan tags: trunk
17:54
Enable use of the __builtin_bswap32() only with GCC 4.3 and higher. check-in: 030f60a7 user: mistachkin tags: trunk
17:14
Avoid freeing the array of instance matches each time the fts5 xNext() method is called. check-in: b9b0c1e5 user: dan tags: trunk
14:34
New command-line options for speedtest1: --multithread, --nomemstat, --serialized, and --singlethread check-in: 2b756722 user: drh tags: trunk
2015-07-02
20:12
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. check-in: 4d8f03dc user: dan tags: trunk
19:47
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. check-in: e53d497c user: drh tags: trunk
18:52
Minor change to mkfts5c.tcl so that fts5.c can be used according to the instructions in loadext.html. check-in: edbcccd3 user: dan tags: trunk
18:16
Add fts5_source_id() SQL function, similar to sqlite_source_id(). check-in: ec257348 user: dan tags: trunk
16:52
Fix harmless compiler warnings and one macro VVA_ONLY macro usage issue. check-in: bcc8a755 user: mistachkin tags: trunk
16:50
Simplify FTS5 handling in the MSVC makefile. check-in: f022e043 user: mistachkin tags: trunk
16:29
Fix a (harmless) shadowed local variable definition in the integrity_check logic. check-in: 3a26a919 user: drh tags: trunk
16:17
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. check-in: 251a7590 user: drh tags: trunk
15:52
Remove "#ifdef SQLITE_ENABLE_FTS5" from individual fts5 source files. Add a single "#if !defined(SQLITE_CORE) || defined(SQLITE_ENABLE_FTS5)" to fts5.c. check-in: 7819002e user: dan tags: trunk
01:38
Add the --shrink-memory option to the speedtest1 test program. check-in: c9ddbd88 user: drh tags: trunk
2015-07-01
19:59
Avoid create a stack from in sqlite3BackupUpdate() in the common case where the first argument is NULL. check-in: 2a897b9e user: drh tags: trunk
17:53
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. check-in: 550705fc user: drh tags: trunk
04:08
Fix some harmless compiler warnings. check-in: 307195c8 user: drh tags: trunk
01:31
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. check-in: 59ad912c user: drh tags: trunk
2015-06-30
17:28
Make use of the _byteswap_ushort() and _byteswap_ulong() compiler intrinsics for MSVC, when available. check-in: fe144dd7 user: mistachkin tags: trunk
15:10
Make use of built-in bswap32() and bswap16() functions in GCC/Clang for a significant performance improvement there. check-in: 8bfcda3d user: drh tags: trunk
14:01
Only use __builtin_bswap16() with GCC 4.8 and later. Closed-Leaf check-in: ce8177e3 user: drh tags: bswap-functions
13:28
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. check-in: 79ff36b7 user: drh tags: bswap-functions
12:47
Make use of htonl() and __builtin_bswap32() for faster implementations of sqlite3Get4byte() and sqlite3Put4byte(). check-in: bc27ebd7 user: drh tags: bswap-functions
11:07
Change an unreachable branch into an assert() in sqlite3PagerAcquire() and optimize sqlite3PcacheOpenSavepoint() by factoring out rarely used code into a subroutine. check-in: b406b20e user: drh tags: trunk
03:57
Optimization to the sqlite3PcacheFetch() logic. check-in: d9a0481c user: drh tags: trunk
03:34
Put all variable declarations for sqlite3PagerWrite() at the beginning of the block. Syntax only - no logic changes. check-in: a0fa6b3b user: drh tags: trunk
03:18
Implement sqlite3Strlen30() using strlen() from the C library. check-in: 8001aa52 user: drh tags: trunk
03:13
Change sqlite3ApiExit() so that its first argument is never NULL. check-in: 791b706e user: drh tags: trunk
02:47
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. check-in: 429ccef2 user: drh tags: trunk
01:25
Convert several 5-year-old and older NEVER() macros into assert(). check-in: ed54c14e user: drh tags: trunk
2015-06-29
23:01
From sqlite3BtreeInsert(), bypass the btreeMoveto() routine for table inserts and go directly to sqlite3BtreeMovetoUnpacked(). check-in: 53fe685d user: drh tags: trunk
20:53
Add a bypass path in sqlite3PagerWrite() for pages with the PGHDR_WRITEABLE bit set, for about a 1% performance increase. check-in: ba425a6a user: drh tags: trunk
19:08
Combine subjRequiresPage() and subjournalPage() into a single subjournalPageIfRequired() routine. check-in: 3b65eb56 user: drh tags: trunk
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. check-in: 7c4ef7b7 user: drh tags: trunk
18:14
Fix over-length source code lines in pager.c. check-in: 14de3d39 user: drh tags: trunk
15:41
Fix minor problems in the ota demo application. check-in: 6aaaec6e user: dan tags: trunk
14:11
Simplifications and performance improvement in pager_write(). check-in: ab7aeeea user: drh tags: trunk
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. check-in: 8619fc34 user: drh tags: trunk
03:28
Very small size reduction and performance increase in sqlite3BitvecTest(). check-in: 9b3a7281 user: drh tags: trunk
00:52
Move an assert() and testcase() into their correct position within getAndInitPage(). check-in: 18115164 user: drh tags: trunk
00:21
Use tail recursion in pcache1Unpin() to get a small size reduction and speed improvement. check-in: fde70472 user: drh tags: trunk
2015-06-28
17:33
Comment typo fix and minor cleanup in the pager. No logic changes. check-in: 94ef1701 user: drh tags: trunk
02:58
Avoid unnecessary calls to sqlite3VdbeSerialTypeLen() for integer serial types, for a small size reduction and a speed increase. check-in: 9cd30d33 user: drh tags: trunk
2015-06-27
23:55
Make greater use of BtCursor.curIntKey. check-in: 63998471 user: drh tags: trunk
22:49
Add the BtCursor.curIntKey field and use it for a small size reduction and performance boost. check-in: 4a17df13 user: drh tags: trunk
20:55
Enhancements to the previous check-in to make it a little smaller and faster. check-in: 291d9e0c user: drh tags: trunk
19:45
Performance improvements in moveToChild() by shifting some work over to getAndInitPage(). Net improvement is about 800K cycles at cost of 30 bytes. check-in: 1956a4ce user: drh tags: trunk
15:51
Manually inline the call from getAndInitPage() to btreeGetPage() for a savings of 2.5 million cycles at a cost of less than 100 bytes. check-in: 7f65b96b user: drh tags: trunk
14:59
Add releasePageNotNull() as an alternative to releasePage() when the argument is guaranteed to be non-NULL, and use it for a small performance gain. check-in: 9383a688 user: drh tags: trunk
03:58
Add the Mempage.aDataOfst field and use it in sqlite3BtreeMovetoUnpacked() for about a 2 million cycle gain. check-in: bee94dc3 user: drh tags: trunk
2015-06-26
20:45
Treat compilation of FTS5 for the loadable extension specially with MSVC. check-in: 7c610276 user: mistachkin tags: trunk
20:25
Merge fts5 branch into trunk. check-in: d27d9965 user: dan tags: trunk
20:14
Merge latest trunk with this branch. Closed-Leaf check-in: 8671b9e1 user: dan tags: fts5
20:13
Remove unnecessary lines from fts3.h and main.mk. check-in: c1b268ce user: dan tags: fts5
20:08
Fix a segfault that could follow an OOM error in fts5. check-in: 713239b8 user: dan tags: fts5
19:43
Small size reduction and performance increase on the OP_IdxInsert opcode. check-in: b6bedc2e user: drh tags: trunk
19:33
Merge latest trunk changes with this branch. check-in: 2a1af0f2 user: dan tags: fts5
18:50
Fix some cases in the fts5 code where a corrupt database could cause a buffer overread. check-in: 360c57bb user: dan tags: fts5
18:47
Further optimization of SQL function dispatch. Improvements to opcode documentation. check-in: eaddbf29 user: drh tags: trunk
18:16
Cache the sqlite3_context structure in the P4 operand of VDBE programs for faster SQL function dispatch. check-in: 2abc44eb user: drh tags: trunk