Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
50 check-ins occurring around a611fa96c4a84861.
|
2014-04-14
| ||
| 18:41 | Improve performance in single-threaded mode by having the final merge pass keys directly to the VDBE, instead of going via a final PMA. Closed-Leaf check-in: 02610cd9b7 user: dan tags: threads-experimental | |
| 14:43 | Fix comments on the rtreenode() and rtreedepth() test function in the R-Tree module. check-in: ade5b986e8 user: drh tags: rtree-enhancements | |
| 12:18 | Remove over 300 lines of unused code, code that implemented the older Guttman insertion algorithms that are no longer used. check-in: 3ba5f295c7 user: drh tags: rtree-enhancements | |
| 08:45 | Minor fixes so that builds with SQLITE_MAX_WORKER_THREADS=0 work. check-in: e400bbbf26 user: dan tags: threads-experimental | |
| 07:30 | Improve use of multiple threads in sqlite3VdbeSorterRewind(). check-in: e1bdc4b810 user: dan tags: threads-experimental | |
|
2014-04-13
| ||
| 19:28 | Remove the unused second argument from sqlite3ExprCachePop(). Add an ALWAYS() on an always-true conditional in sqlite3VdbeResolveLabel(). check-in: ab23abf392 user: drh tags: trunk | |
| 19:15 | Make sure column cache elements are cleared correctly when jumping over code for key generation in a partial index. Fix for ticket [2ea3e9fe6379fc3f6]. check-in: 3122b83640 user: drh tags: trunk | |
| 16:10 | Continuing work on the new custom query mechanism for r-tree. check-in: ca7357e66c user: drh tags: rtree-enhancements | |
|
2014-04-12
| ||
| 19:34 | Fix many issues with new code. check-in: 62c406a042 user: dan tags: threads-experimental | |
| 17:44 | Continuing clean-up of the R-Tree module in preparation for cutting in the new generalized query mechanism. check-in: 66c858f205 user: drh tags: rtree-enhancements | |
|
2014-04-11
| ||
| 23:14 | Add the new interfaces to rtree, though they do not yet work. Add the "show_speedtest1_rtree.tcl" script for showing the test data used for the R-Tree tests of speedtest1. Change speedtest1 to generate better R-Tree test data. check-in: 0b70275972 user: drh tags: rtree-enhancements | |
| 19:43 | Avoid having the sorter merge too many PMAs at a time when incrementally merging data following a SorterRewind(). check-in: 98bf0307b1 user: dan tags: threads-experimental | |
| 17:41 | Add the --verify option to speedtest1. Add verification test cases to the "rtree" testset and a case that uses a custom geometry callback. check-in: 9d485c4207 user: drh tags: rtree-enhancements | |
| 16:14 | Update comments in the R-Tree module in preparation for some big changes. Add an "rtree" performance test to speedtest1. check-in: 20a73ec0b2 user: drh tags: rtree-enhancements | |
|
2014-04-10
| ||
| 02:24 | Modify the OR-clause handling so that it can safely deal with OR-clause with 17 or more terms. Fix for ticket [10fb063b1179be53ea0b53bb]. check-in: a67b5312f6 user: drh tags: trunk | |
|
2014-04-09
| ||
| 20:04 | Experimental multi-threaded sorting changes to allow the sorter to begin returning items to the VDBE before all data is sorted. check-in: f9d5e09afa user: dan tags: threads-experimental | |
|
2014-04-07
| ||
| 18:44 | Experimental multi-threaded sorting changes to begin merging PMAs before SorterRewind() is called. Closed-Leaf check-in: cbfc0f6d49 user: dan tags: abandoned | |
|
2014-04-04
| ||
| 22:44 | Fix harmless compiler warnings. check-in: e54dded201 user: drh tags: threads | |
| 21:40 | Fix typo in a Windows threading support routine. check-in: 5e3dfa27c7 user: mistachkin tags: threads | |
| 18:49 | Performance improvements when reading large blobs, especially if SQLITE_DIRECT_OVERFLOW_READ is defined. check-in: 2312eb6a9e user: drh tags: trunk | |
| 18:37 | Merge the latest trunk changes into the threads branch. check-in: 39ac79cffe user: drh tags: threads | |
| 18:20 | Merge changes to the query planner that strive to ensure that any index usage that is a proper subset of some other index usage always has a slightly higher cost. check-in: 683dd379a2 user: drh tags: trunk | |
| 14:12 | Ensure the "PRAGMA journal_mode=WAL" works coming from any other journal_mode with ATTACH-ed databases. check-in: e54330b431 user: drh tags: trunk | |
| 07:52 | Add test file sort3.test, which should have been part of commit [9d3351b8d7]. check-in: dceed2c803 user: dan tags: threads | |
| 02:13 | Change vdbeSorterExtendFile() so that it makes a best effort to create the PMA file of the desired size, but does not return an error if unable. check-in: 217814bc4b user: drh tags: threads | |
|
2014-04-03
| ||
| 16:53 | Version 3.8.4.3 Leaf check-in: a611fa96c4 user: drh tags: release, version-3.8.4.3, branch-3.8.4 | |
| 16:42 | Merge all recent changes from trunk. check-in: a0910079ad user: drh tags: threads | |
| 16:35 | Merge all recent changes from trunk, including the fix for the OP_SCopy-vs-OP_Copy problem. check-in: 9515c8344a user: drh tags: sessions | |
| 16:29 | Use OP_Copy instead of OP_SCopy when moving results out of a subquery, to prevent the subquery results from changing out from under the outer query. Fix for ticket [98825a79ce1456]. Problem introduced by check-in [1e64dd782a126f48d78]. check-in: d5513dfa23 user: drh tags: trunk | |
| 16:25 | Fix an integer overflow problem in the sorter. check-in: 9d3351b8d7 user: dan tags: threads | |
| 16:18 | Increase the version number to 3.8.4.3 check-in: f05a49b6e0 user: drh tags: branch-3.8.4 | |
| 16:16 | Use OP_Copy instead of OP_SCopy when moving results out of a subquery, to prevent the subquery results from changing out from under the outer query. Fix for ticket [98825a79ce1456]. Problem introduced by check-in [1e64dd782a126f48d78]. check-in: ec6a06246e user: drh tags: branch-3.8.4 | |
| 14:31 | Fix a typo in the "Synopsis:" comment for the OP_VFilter opcode. check-in: 48ecdd4aff user: drh tags: trunk | |
| 14:29 | Fix minor errors causing compilation to fail with SQLITE_MAX_WORKER_THREADS set to a value greater than zero. check-in: 0561272abf user: dan tags: threads | |
| 02:54 | Refactor local object and method names in vdbesort.c so that their names more closely reflect their actual use. check-in: d284e30eb1 user: drh tags: threads | |
| 00:32 | In the command-line shell, run set writable_schema before running the ".clone" command. check-in: 9d2ae6342c user: drh tags: trunk | |
|
2014-04-02
| ||
| 18:58 | Add a big introductory comment to vdbesort.c explaining its operation at a high level. Also adjust some symbolic names and fix other comment issues in that file. check-in: eef60f1bf5 user: drh tags: threads | |
| 15:15 | Fix some problems with OOM handling in vdbesort.c. check-in: 47e702bd83 user: dan tags: threads | |
| 14:38 | Change the name of the SorterThread object to "SortSubtask" to avoid confusion with the SQLiteThread object. check-in: 4ee2d910fb user: drh tags: threads | |
|
2014-04-01
| ||
| 18:41 | When sorting data for a CREATE INDEX statement in single-threaded mode, assume that keys are delivered to the sorter in primary key order. Also fix various comments that had fallen out of date. check-in: 821d1ac450 user: dan tags: threads | |
| 15:38 | Even if compile time option SQLITE_MAX_WORKER_THREADS is set to one or greater, set the default number of worker threads to zero. Distribute data more evenly between threads in sqlite3VdbeSorterWrite() to improve performance when sorting large amounts of data. Add new test file sort2.test. check-in: 643c86a056 user: dan tags: threads | |
| 10:19 | Fix a problem with OOM handling in the sorter code. check-in: 59cd5229e2 user: dan tags: threads | |
| 01:24 | Remove an unnecessary conditional, replacing it with an assert(). Improvements to comments. Closed-Leaf check-in: 834bf1c367 user: drh tags: overflow-pgno-cache | |
|
2014-03-31
| ||
| 23:57 | Fix a compiler warning when SQLITE_DIRECT_OVERFLOW_READ is defined. Minor performance enhancement and size reduction. check-in: 96385dc460 user: drh tags: overflow-pgno-cache | |
| 22:03 | Merge in the latest changes and fixes from trunk. check-in: f6211540c9 user: drh tags: overflow-pgno-cache | |
| 20:05 | Remove an unnecessary conditional. Closed-Leaf check-in: 7473c4dfc1 user: drh tags: query-plan-experiments | |
| 19:57 | Add the SQLITE_MAX_WORKER_THREADS compile time option. And the SQLITE_CONFIG_WORKER_THREADS sqlite3_config() switch. check-in: 2774710df8 user: dan tags: threads | |
| 19:49 | Also make sure an index that is a proper subset of some other index has a higher cost than that other index. Add test cases. check-in: b7830d232b user: drh tags: query-plan-experiments | |
| 18:24 | Make sure that an index that covers a proper superset of the WHERE clause terms of some other index has a lower cost than the other index. check-in: ea8b091004 user: drh tags: query-plan-experiments | |
| 13:42 | Avoid a (harmless) buffer overread that is possible on an OOM when MEMSYS5 is engaged. check-in: b3296267fb user: drh tags: trunk | |