Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
|
2015-06-29
| ||
| 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: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) | |
| 17:10 | Merge changes to get FTS5 working with MSVC. (check-in: 954231d2 user: mistachkin tags: fts5) | |
| 16:55 | Merge upstream changes. Get the test fixture working with FTS5. Fix compiler warnings. (Closed-Leaf check-in: bfcd1608 user: mistachkin tags: fts5Msvc) | |
| 16:42 | Remove fts5 initialization code from core file main.c. (check-in: c91a93b3 user: dan tags: fts5) | |
| 16:17 | Add FTS5 DLL target for MSVC. (check-in: be85b824 user: mistachkin tags: fts5Msvc) | |
| 04:34 | Initial changes to get FTS5 working with MSVC. (check-in: ef2052f8 user: mistachkin tags: fts5Msvc) | |
|
2015-06-25
| ||
| 20:36 | Fix Makefile.in to account for recent changes. Update fts5 test scripts so that they do not run if SQLITE_ENABLE_FTS5 is not defined. (check-in: 31752207 user: dan tags: fts5) | |
| 20:16 | Merge latest trunk changes into this branch. (check-in: fcd8f7ce user: dan tags: fts5) | |
| 20:10 | Add a script to combine all fts5 code into a single file - fts5.c - that can be used to build an SQLite loadable extension. (check-in: 46e86b06 user: dan tags: fts5) | |
|
2015-06-23
| ||
| 18:47 | Improve test coverage of fts5. (check-in: df5ccea8 user: dan tags: fts5) | |
| 15:06 | Merge latest trunk changes with this branch. Add tests for columnsize=0. (check-in: ef44c71a user: dan tags: fts5) | |
|
2015-06-10
| ||
| 10:45 | Fix the fts5 xRename() method. (check-in: 0f7fd513 user: dan tags: fts5) | |
|
2015-06-09
| ||
| 20:58 | Add the "columnsize=" option to fts5, similar to fts4's "matchinfo=fts3". (check-in: aa12f9d9 user: dan tags: fts5) | |
|
2015-06-06
| ||
| 19:23 | Fix a comment in fts5.h. (check-in: e964b587 user: dan tags: fts5) | |
| 16:28 | Fix handling of fts5 rowid constraints in the absence of a MATCH clause. Add tests to cover recently added branches. (check-in: 3a9cb648 user: dan tags: fts5) | |
|
2015-06-05
| ||
| 19:05 | Make use of range constraints on the rowid field of an fts5 table in full-text queries. (check-in: 32cbc0ed user: dan tags: fts5) | |
|
2015-06-03
| ||
| 11:23 | Fix an fts5 problem in extracting columns from position lists containing large varints. (check-in: 4ea015ab user: dan tags: fts5) | |
|
2015-06-02
| ||
| 19:38 | Change the fts5 multi-column syntax to use parenthesis instead of square brackets. (check-in: ab85a6fc user: dan tags: fts5) | |
| 18:07 | Merge latest trunk changes with this branch. (check-in: c9ffda4a user: dan tags: fts5) | |
| 17:57 | Reimplement [ec69e09a] so that each call to the xNext() method does not involve two iterations of the match expression tree (only one). (check-in: 80fe305b user: dan tags: fts5) | |
|
2015-06-01
| ||
| 19:17 | Improve performance of the fts5 AND operator. (check-in: b43e9a5b user: dan tags: fts5) | |
| 09:15 | Change fts5 expression processing to avoid linear scans of long doclists caused by phrases that match specific columns only. (check-in: ec69e09a user: dan tags: fts5) | |
|
2015-05-30
| ||
| 11:49 | Remove the "#include sqlite3Int.h" from fts5Int.h. (check-in: e008c3c8 user: dan tags: fts5) | |
|
2015-05-29
| ||
| 19:00 | Add extra tests and fixes for multi-column matches. (check-in: ae6794ff user: dan tags: fts5) | |
| 15:55 | Add syntax to fts5 used to specify that a phrase or NEAR group should match a subset of columns. For example "[col1 col2 ...] : <phrase>". (check-in: 0fc0ea20 user: dan tags: fts5) | |
|
2015-05-28
| ||
| 19:57 | Optimizations for fts5 queries that match against a specific column. (check-in: b29ac50a user: dan tags: fts5) | |
| 14:37 | Remove some dead code from fts5. Add auxiliary function api tests to the same. (check-in: 0f9df202 user: dan tags: fts5) | |
|
2015-05-26
| ||
| 18:22 | Simplifications and minor optimizations to fts5 prefix queries that cannot use a prefix index. (check-in: aef89d9f user: dan tags: fts5) | |
|
2015-05-25
| ||
| 11:46 | Avoid redundant loads from the %_data table in the fts5 code. (check-in: 02069782 user: dan tags: fts5) | |
|
2015-05-23
| ||
| 15:43 | Avoid making redundant copies of position-lists within the fts5 code. (check-in: 5165de54 user: dan tags: fts5) | |
|
2015-05-22
| ||
| 07:44 | Increase test coverage of fts5_vocab.c. (check-in: 065ab83a user: dan tags: fts5) | |
| 06:08 | Improve test coverage of fts5_unicode2.c. (check-in: fea8a4db user: dan tags: fts5) | |
|
2015-05-20
| ||
| 09:27 | Improve test coverage of fts5_tokenize.c. (check-in: 0e91a6a5 user: dan tags: fts5) | |
|
2015-05-19
| ||
| 19:37 | Add tests for fts5 tokenizers. (check-in: 4f90ba20 user: dan tags: fts5) | |
| 11:38 | Update Makefile.in so that the amalgamation files built by "make sqlite3.c" include fts5. (check-in: 2870a805 user: dan tags: fts5) | |
| 11:32 | Fix a memory leak that could follow an OOM condition in fts5. (check-in: de9f8ef6 user: dan tags: fts5) | |
|
2015-05-18
| ||
| 20:34 | Improve test coverage of fts5_storage.c. (check-in: 4dfe2e58 user: dan tags: fts5) | |
| 18:24 | Fix a bug in test script fts5fault4.test. (check-in: a5080593 user: dan tags: fts5) | |
| 18:03 | Add a test for an untested branch in fts5_expr.c. (check-in: ce08206b user: dan tags: fts5) | |
| 17:50 | Improve test coverage of fts5_config.c. (check-in: 47dbfadb user: dan tags: fts5) | |
|
2015-05-16
| ||
| 20:04 | Further test coverage improvements for fts5. (check-in: 927d9a64 user: dan tags: fts5) | |
|
2015-05-15
| ||
| 18:13 | Improve test coverage of fts5_index.c. (check-in: 7aea8c6d user: dan tags: fts5) | |
| 12:18 | Add test cases. And some fixes. (check-in: adee7885 user: dan tags: fts5) | |
|
2015-05-13
| ||
| 18:12 | Merge latest trunk changes with this branch. (check-in: b5f0e8c5 user: dan tags: fts5) | |
| 17:15 | Change fts5 doclist-index structures to be trees instead of flat lists. This only makes a difference for databases that contain millions of instances of the same token. (check-in: aa34bf66 user: dan tags: fts5) | |
|
2015-05-09
| ||
| 18:28 | Allow the fts5vocab table to optionally provide data on a per-column basis. (check-in: 39222761 user: dan tags: fts5) | |
|
2015-05-08
| ||
| 20:21 | Add the fts5vocab module, for direct access to the fts5 index. (check-in: 6bf93e3b user: dan tags: fts5) | |
| 09:21 | Improve the error message returned by FTS5 if it encounters an unknown file format. (check-in: f369caec user: dan tags: fts5) | |
|
2015-05-07
| ||
| 19:29 | Change to storing all keys in a single merge-tree structure instead of one main structure and a separate one for each prefix index. This is a file-format change. Also introduce a mechanism for managing file-format changes. (check-in: a684b5e2 user: dan tags: fts5) | |
|
2015-05-02
| ||
| 20:35 | Reorganize some of the fts5 expression parsing code. Improve test coverage of the same. (check-in: c4456dc5 user: dan tags: fts5) | |
|
2015-05-01
| ||
| 20:38 | Further improvements to test coverage of fts5 code. (check-in: d4331943 user: dan tags: fts5) | |
| 12:14 | Improve test coverage of fts5.c. (check-in: add4f468 user: dan tags: fts5) | |
|
2015-04-29
| ||
| 20:54 | Improve fts5 tests. (check-in: c1f07a3a user: dan tags: fts5) | |
|
2015-04-28
| ||
| 20:24 | Fix an fts5 bug in handling writes while there are active cursors. (check-in: 07f70955 user: dan tags: fts5) | |
| 18:35 | Improve coverage of fts5 tests. (check-in: 8e8136f2 user: dan tags: fts5) | |
|
2015-04-27
| ||
| 16:21 | Change the fts5 content= option so that it matches fts5 columns with the underlying table columns by name, not by their position within the CREATE TABLE statement. (check-in: e38e2bb6 user: dan tags: fts5) | |
| 11:31 | Further tests for fts5. (check-in: ffeb3ef3 user: dan tags: fts5) | |
|
2015-04-25
| ||
| 20:29 | Improve coverage of fts5_index.c slightly. (check-in: e5aaa013 user: dan tags: fts5) | |
| 18:56 | Add tests for fts5. (check-in: e748651c user: dan tags: fts5) | |
|
2015-04-24
| ||
| 20:18 | Merge latest trunk changes with this branch. (check-in: 1c78d892 user: dan tags: fts5) | |
| 19:41 | Add the "unindexed" column option to fts5. (check-in: 86309961 user: dan tags: fts5) | |
| 15:56 | Add extra tests for corrupt database handling in fts5. (check-in: 41449f7a user: dan tags: fts5) | |
| 06:02 | Fix an fts5 build problem in main.mk. (check-in: 60045ced user: dan tags: fts5) | |
|
2015-04-22
| ||
| 20:58 | Add extra OOM tests for fts5. (check-in: 2dd59b57 user: dan tags: fts5) | |
| 20:14 | Fix problems with doclist-indexes involving very large rowids. (check-in: 1e599409 user: dan tags: fts5) | |
| 09:40 | Update this branch with latest trunk changes. (check-in: 9797482d user: dan tags: fts5) | |
|
2015-04-21
| ||
| 20:13 | Fix a problem in fts5fault1.test. (check-in: a21d60cb user: dan tags: fts5) | |
| 19:07 | Fix an fts5 problem with large deletes. (check-in: e50e8031 user: dan tags: fts5) | |
|
2015-04-20
| ||
| 18:48 | Fix some fts5 problems with very large position lists. (check-in: 2ea8f9cb user: dan tags: fts5) | |
|
2015-04-15
| ||
| 18:49 | Logically store updates as (insert+delete) within the FTS tree. This allows keys to be annihilated more quickly under some circumstances. (check-in: 50fae1f0 user: dan tags: fts5) | |
| 16:01 | Fix a problem preventing doclist indexes from being loaded. (check-in: b29109a0 user: dan tags: fts5) | |
|
2015-04-14
| ||
| 20:15 | Begin changing fts5 to use a delete flag so that delete markers may be annihilated more quickly. (check-in: 9341c070 user: dan tags: fts5) | |
|
2015-04-11
| ||
| 18:25 | Have fts5 integrity check verify that prefix indexes contain the same values as returned by prefix queries on the main terms index. (check-in: bdb8e82a user: dan tags: fts5) | |
| 16:23 | Improve fts5 integrity-check so that it checks that DESC queries return the same as ASC. Change the poslist format slightly to make room for a delete-flag. (check-in: 49c1e745 user: dan tags: fts5) | |
|
2015-03-21
| ||
| 15:45 | Merge trunk changes with this branch. (check-in: 14274391 user: dan tags: fts5) | |
| 15:37 | When scanning the full-text index as part of the fts5 integrity-check, also run a point query for every term and verify that these results are consistent with those found by the linear scan. (check-in: ce972f6a user: dan tags: fts5) | |
|
2015-03-11
| ||
| 14:51 | Add an optimization to the fts5 unicode tokenizer code. (check-in: f5db4892 user: dan tags: fts5) | |
|
2015-03-10
| ||
| 19:24 | Avoid redundant string comparisons while merging fts5 segment b-trees. (check-in: 5c46820d user: dan tags: fts5) | |
|
2015-03-07
| ||
| 15:46 | Fix some compiler warnings caused by signed/unsigned pointer conversions. (check-in: cccee7b5 user: dan tags: fts5) | |
| 11:50 | Fix the bm25() function so that it multiplies scores by -1 before returning them. This means better matches have a lower numerical score, so "ORDER BY rank" (not "ORDER BY rank DESC") does what you want. (check-in: 3ee7b5a9 user: dan tags: fts5) | |
|
2015-03-04
| ||
| 08:29 | Fix a couple of build problems. (check-in: a5d5468c user: dan tags: fts5) | |
|
2015-02-27
| ||
| 09:41 | Further minor optimizations to flushing fts5 data to disk. (check-in: a07dcca9 user: dan tags: fts5) | |