Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
16 check-ins using file src/btree.c version ae7687fa
|
2018-06-08
| ||
| 18:22 | Consider doing a partial table scan to fulfill an IN operator rather than using an index. Try to pick the plan with the lowest cost. (check-in: 1fa40a78 user: drh tags: in-scan-vs-index) | |
|
2018-06-07
| ||
| 18:13 | The IN-early-out optimization: When doing a look-up on a multi-column index and an IN operator is used on a column other than the left-most column, then if no rows match against the first IN value, check to make sure there exist rows that match the columns to the right before continuing with the next IN value. (check-in: 09fffbdf user: drh tags: trunk) | |
| 18:01 | Fix the assert()s in the byte-code engine that prove that cursors are unidirectional. (Closed-Leaf check-in: 4b0b4e14 user: drh tags: multikey-opt-idea) | |
| 17:32 | Remove the NextIfOpen and PrevIfOpen opcodes which are no longer needed when the IN-early-out optimization is working. (check-in: 439c8162 user: drh tags: multikey-opt-idea) | |
| 16:07 | Test cases. (check-in: 085e8637 user: drh tags: multikey-opt-idea) | |
| 15:28 | Merge the ".stat/.eqp" CLI fix from trunk. (check-in: a91cad33 user: drh tags: multikey-opt-idea) | |
| 15:23 | Avoid using a prepared statement for ".stats on" after it has been closed by the ".eqp full" logic. Fix for ticket [7be932dfa60a8a6b3b26bcf76]. (check-in: bb87c054 user: drh tags: trunk) | |
| 14:59 | Add the WHERE_IN_EARLYOUT flag and use it to clarify the logic of this optimization. (check-in: 522f1eac user: drh tags: multikey-opt-idea) | |
| 14:32 | Merge recent trunk enhancements. (check-in: e9d7bf4f user: drh tags: multikey-opt-idea) | |
|
2018-06-06
| ||
| 23:31 | Change a comma into a logically equivalent but semantically clearer semicolon. (check-in: 71f97f0f user: drh tags: trunk) | |
| 20:55 | More space and performance enhancements to sqlite3VdbeRecordCompare(). (check-in: 83a60ff0 user: drh tags: trunk) | |
| 20:29 | Small performance optimization in sqlite3VdbeRecordCompareWithSkip() for the common case where the comparison is equal. (check-in: 1e616e25 user: drh tags: trunk) | |
| 19:48 | Rearrange the order of some checks in the integrity_check pragma for a very slight performance gain. (check-in: 4b853f02 user: drh tags: trunk) | |
| 18:50 | Fix the sqlite3BeginTrans() calls within the snapshot extension. (check-in: 1fef7ad2 user: drh tags: trunk) | |
| 17:45 | Another minor optimization to OP_Transaction. (check-in: d80077ae user: drh tags: trunk) | |
| 16:28 | Change sqlite3BtreeBeginTrans() to return the BTREE_SCHEMA_COOKIE, for a small speed improvement when starting new transactions. (check-in: a10662aa user: drh tags: trunk) | |