Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Changes In Branch pushdown-optimization Excluding Merge-Ins
This is equivalent to a diff from 2d0b64316d to 91dfb61a1a
|
2017-04-29
| ||
| 15:27 | Evaluate WHERE clause terms that reference only the index before evaluating terms that require the table, and thereby avoid seeking the table row if index terms are false. This is called the "push-down" optimization in the MySQL world, we are told. Do not confuse with [/info/6df18e949d367629|WHERE-clause push-down]. (check-in: d7bb79ed3a user: drh tags: trunk) | |
| 14:56 | Minor size and performance improvements to the push-down optimization. (Closed-Leaf check-in: 91dfb61a1a user: drh tags: pushdown-optimization) | |
|
2017-04-28
| ||
| 19:59 | Within a loop that uses a non-covering index test, test non-indexed terms that can be tested without seeking the main table cursor before those that cannot. (check-in: afe68f0a80 user: dan tags: pushdown-optimization) | |
|
2017-04-26
| ||
| 20:45 | Experimental implementation of pessimistic page-level locking based on rollback mode. (check-in: 64ecf7c7e5 user: dan tags: server-edition) | |
| 17:21 | Add new test file cachespill.test. (check-in: 2d0b64316d user: dan tags: trunk) | |
| 14:34 | Replace <fts5.h> with "fts5.h" in test file fts5_test_tok.c. (check-in: 63d9ca5c73 user: dan tags: trunk) | |
Changes to src/wherecode.c.
Added test/pushdown.test.