Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
50 check-ins occurring around ad71c72be56786d8.
|
2013-10-05
| ||
| 02:56 | In the index_list pragma, make sure the "r" column is the same on output as it was on input in the sqlite_stat1 table. (Closed-Leaf check-in: de78250ad2 user: drh tags: index-scan-rate) | |
|
2013-10-04
| ||
| 20:39 | Merge trunk changes. (check-in: c6ac80ed8d user: drh tags: index-scan-rate) | |
| 18:29 | Further refinements of the index scanning speed logic. (check-in: e5d9371da9 user: drh tags: index-scan-rate) | |
| 18:17 | If an "INSERT INTO ... SELECT" can use the xfer optimization, pass the OPFLAG_BULKCSR hint to btree cursors used to update indices. This results in a tighter key packing. (check-in: 087af29ee2 user: dan tags: trunk) | |
| 15:58 | Fix test cases so that they work when the query planner uses index size estimates to determine whether or not to try an covering index scan. (check-in: 2f394de88f user: drh tags: index-scan-rate) | |
| 15:30 | Improved estimates of the relative speed of index scans based on declared datatypes of columns in the table. Add "r" column to PRAGMA index_info, showing the estimated relative scan rate. (check-in: 07462bb605 user: drh tags: index-scan-rate) | |
| 02:36 | Progress toward using the iScanRatio information on indices. Many tests are still failing. (check-in: 6c352edbba user: drh tags: index-scan-rate) | |
| 00:00 | Make sure the count(*) optimization works correctly even when partial indices are present. Ticket [a5c8ed66cae]. (check-in: 9f2f4c0a50 user: drh tags: trunk) | |
|
2013-10-03
| ||
| 20:41 | Have FTS take advantage of "docid<?" constraints when they are present. Extend the FTS "incremental doclist" optimization so that it is used for tokens within multi-token phrases. (check-in: baf8ce5916 user: dan tags: trunk) | |
| 20:28 | Merge latest trunk changes. (Closed-Leaf check-in: 24aa20da22 user: dan tags: fts4-docid-range-constraints) | |
| 19:27 | Allow FTS4 multi-token phrases to use a combination of in-memory and incrementally loaded doclists. This allows phrases to (partially) benefit from incremental doclists without disabling the deferred token optimization. (check-in: f6819c5f33 user: dan tags: fts4-docid-range-constraints) | |
| 19:21 | Experimental branch allowing different postulated scan rates for each index. (check-in: d59d97b0a8 user: drh tags: index-scan-rate) | |
| 15:39 | The sqlite3FixInit() routine cannot fail. So change the return type from "int" to "void". (check-in: 500c5932fe user: drh tags: trunk) | |
| 14:08 | Rework the PRAGMA implementation to only call sqlite3ReadSchema() from a single place, based on a flag in the pragma table, rather than separately from each case which needs the schema. (check-in: 8338232a11 user: drh tags: trunk) | |
| 12:29 | Return an error if an attempt is made to create a trigger with an SQL variable embedded within it. If such a variable reference is found within a trigger definition loaded from the sqlite_master table, silently replace it with a NULL. (check-in: f35f6ae3da user: dan tags: trunk) | |
| 11:27 | Remove unnecessary memset() calls from test code. (check-in: eec3187bc6 user: drh tags: trunk) | |
|
2013-10-02
| ||
| 20:46 | In the lemon parser generator, change all hashes to unsigned to avoid potential problems with signed integer overflow. (check-in: 8d399a03de user: drh tags: trunk) | |
| 08:04 | Add a test to check that the new multi-token phrase optimization is actually helping. (check-in: bc3a2ed5fb user: dan tags: fts4-docid-range-constraints) | |
|
2013-10-01
| ||
| 20:29 | Bring some file format comments in btreeInt.h up to date. (check-in: 012d54d0d2 user: drh tags: trunk) | |
| 20:10 | Merge trunk changes with this branch. (check-in: 65d9c6fafb user: dan tags: fts4-docid-range-constraints) | |
| 20:02 | Allow multi-token phrases to load doclists from the database incrementally. This allows queries that feature such phrases to benefit from the "docid<?" optimization. (check-in: ea543f081d user: dan tags: fts4-docid-range-constraints) | |
| 19:36 | Fix comments in the fast_vacuum.c demonstration program. (check-in: e0db7b38e1 user: drh tags: trunk) | |
| 19:02 | Add the "fast_vacuum.c" demonstration program to the tool/ subdirectgory. (check-in: 2b60320d57 user: drh tags: trunk) | |
| 15:30 | Change the ".dump" command in the command-line shell so that it COMMITs if there are database corruption errors but invokes ROLLBACK on any other kind of error. (check-in: 473234632f user: drh tags: trunk) | |
|
2013-09-30
| ||
| 19:33 | Fix a minor typo in a comment in where.c. (check-in: 9c9fa151e9 user: drh tags: trunk) | |
| 19:05 | Add some timing tests to the amatch test script. (check-in: ad71c72be5 user: drh tags: trunk) | |
| 18:16 | Merge trunk changes with this branch. (check-in: e294a9c7c5 user: dan tags: fts4-docid-range-constraints) | |
| 18:14 | Fix a performance problem in the FTS4 auxiliary functions triggered by an OR clause in the full-text query. (check-in: fa0f2f0e3e user: dan tags: trunk) | |
| 17:37 | Fix memory leaks in the amatch extension. Add a few simple test cases. (check-in: 604134732e user: drh tags: trunk) | |
| 11:42 | Have fts4 full-text queries consider "docid<?" and similar constraints. (check-in: 6622424a3a user: dan tags: fts4-docid-range-constraints) | |
| 11:01 | Update and modernize an obsolete comment associated with VACUUM. No changes to code. (check-in: 94c914e3fa user: drh tags: trunk) | |
|
2013-09-29
| ||
| 04:56 | Fix typo in comment. No changes to code. (check-in: 0b7bd46825 user: mistachkin tags: trunk) | |
|
2013-09-28
| ||
| 16:43 | Add new test file fts3defer3.test. (check-in: a6cd14effe user: dan tags: trunk) | |
| 13:28 | In the nextchar.c extension, allow the second argument to the next_char() function to be a subquery. (check-in: 59b9fa2236 user: drh tags: trunk) | |
| 12:40 | Updates to the sqlite3_analyzer utility: Change the names of some labels, especially change "Fragmentation" to "Non-sequential pages". Revise the computation of non-sequential pages so that it ignores itercalated non-leaf pages (overflow and index pages). (check-in: 3e5c7771fa user: drh tags: trunk) | |
|
2013-09-26
| ||
| 15:21 | Obtain the required shared-cache write-lock when executing "DELETE FROM tbl" statements. Fix for [1e1321ee98]. (check-in: 1f8f4fdf3f user: dan tags: trunk) | |
| 11:04 | Fix a faulty assert() in sqlite3BtreeBeginTrans() that may fail in shared-cache mode. (check-in: 1e1321ee98 user: dan tags: trunk) | |
|
2013-09-24
| ||
| 19:07 | Merge updates from trunk. (check-in: 435ce3b3fc user: mistachkin tags: toTypeFuncs) | |
|
2013-09-18
| ||
| 11:16 | Test that the unicode61 tokenchars= and separators= options work with the fts3tokenize virtual table. (check-in: ed24051462 user: dan tags: trunk) | |
|
2013-09-17
| ||
| 23:36 | Clear the current time value on prepared statements when the prepared statement is reset. (check-in: cebd6fc551 user: drh tags: trunk) | |
|
2013-09-16
| ||
| 20:46 | Readability improvements to the Win32 RC file. (check-in: e645906257 user: mistachkin tags: trunk) | |
| 19:27 | Minor consistency fixes to the Win32 RC file. (check-in: 619c5211b9 user: mistachkin tags: trunk) | |
| 12:57 | The date and time functions use the exact same notion of "now" for every invocation within the same call to sqlite3_step(). (check-in: daf6ba413c user: drh tags: trunk) | |
|
2013-09-13
| ||
| 23:27 | Fix Windows SDK compiler warning. (check-in: d5fc3f1dab user: mistachkin tags: trunk) | |
| 23:26 | Fix test issues for Windows portability. (check-in: 650b32825a user: mistachkin tags: trunk) | |
| 22:38 | VSIX tooling changes to support Visual Studio 2013. (check-in: d56fac4031 user: mistachkin tags: trunk) | |
| 21:03 | Fix the "const" qualifiers on the pragma name table. (check-in: b74e6be818 user: drh tags: trunk) | |
| 21:01 | Add the soft_heap_limit pragma. (check-in: c326356f9a user: drh tags: trunk) | |
| 19:08 | VSIX tooling changes to support Visual Studio 2013. (Leaf check-in: e8ac4a1227 user: mistachkin tags: branch-3.8.0) | |
| 19:00 | Tweak the new PRAGMA name parser to achieve full branch test coverage. (check-in: c82e05c4b8 user: drh tags: trunk) | |