SQLite
Timeline
Not logged in

50 most recent timeline items

2017-08-21
02:20
[56d19f9f] Leaf: Remove an unnecessary conditional. (user: drh, tags: trunk)
02:05
[6538ef7b] Minor optimization to sqlite3VdbeMemSetStr(). (user: drh, tags: trunk)
2017-08-19
20:38
[d01d2cff] Space and size optimization to the printf implementation. (user: drh, tags: trunk)
15:50
[2dd36ade] Leaf: Ensure that write-locks on pages are dropped at the end of each write transaction, even if there is still a read transaction open. (user: dan, tags: server-process-edition)
00:17 • Edit [d0da791ba0edfb65|d0da791b]: Edit check-in comment. (user: drh)
2017-08-18
22:30
[745bc8de] Another size and performance optimization to readDbPage(). This time we eliminate some unnecessary local variables. (user: drh, tags: trunk)
21:14
[ca9e1875] Size and performance optimization the readDbPage() routine in the pager. (user: drh, tags: trunk)
19:28
[605907e7] Leaf: Version 3.19.4 (user: drh, tags: release, branch-3.19, version-3.19.4)
18:55
[abb6e076] Add tests to this branch. (user: dan, tags: server-process-edition)
16:09
[3075cfa0] For the unix VFS, avoid an unnecessary stat() system call prior to opening any file in the common case where there are no unused file descriptors. (user: drh, tags: trunk)
16:04
[66fb9e1c] Do not search for locks to clear when connecting to a db in multi-process mode unless it looks like the previous user of the client-id crashed. (user: dan, tags: server-process-edition)
14:34
[eb1202b5] Combine the OP_CreateTable and OP_CreateIndex opcodes of the bytecode engine into a single OP_CreateBtree opcode. This simplifies the implementation and makes the bytecode programs clearer. (user: drh, tags: trunk)
13:25 • Fixed ticket [e20dd54a]: COLLATE sequence for ORDER/GROUP BY ignored when using an index-on-expression plus 3 other changes (user: drh) ... 1 similar event omitted.
08:29
[37e19008] Only use indexes on expressions to optimize ORDER BY and GROUP BY if the collation sequence matches. Possible fix for [e20dd54a]. (user: dan, tags: trunk)
07:14 • New ticket [e20dd54a] COLLATE sequence for ORDER/GROUP BY ignored when using an index-on-expression. (user: dan)
2017-08-17
20:53
[a42a438c] Use the __builtin_clzll() function of gcc to improve the performance and reduce the size of the sqlite3LogEst() routine. (user: drh, tags: trunk)
19:32
[a8115f95] Add support for crash recovery in multi-process mode. And add test cases for the same. (user: dan, tags: server-process-edition)
19:23
[264a5e1b] Small optimization in the Expr tree walker. (user: drh, tags: trunk)
18:54
[0367a4d5] Size optimization in the authorizer error message generation logic. (user: drh, tags: trunk)
18:23
[f13682ea] In sqlite3ViewGetColumnNames(), return the number of errors, not an error code. (user: drh, tags: trunk)
18:17
[0712f057] The RTREE extension should return SQLITE_CORRUPT_VTAB, not just SQLITE_CORRUPT when it encounters incorrectly formatted shadow tables. (user: drh, tags: trunk)
14:48 • Fixed ticket [be436a7f]: Use-after-free on schema change where RTREE is used inside of a trigger plus 5 other changes (user: drh)
14:47
[fb6ca99b] Remove an unnecessary branch from the [be436a7f4587ce517ddc] fix. (user: drh, tags: trunk)
14:12
[2101b420] Add test cases for ticket [be436a7f4587ce517] using virtual table modules fts5 and rtree. (user: dan, tags: trunk)
02:26
[a7bc7752] Defer schema resets when the query planner is running. Proposed fix for ticket [be436a7f4587ce517]. (user: drh, tags: trunk)
02:25 • New ticket [be436a7f] Use-after-free on schema change where RTREE is used inside of a trigger. (user: drh)
2017-08-16
19:20
[f078deb2] Avoid a test for CURTYPE_BTREE in sqlite3VdbeCursorMoveto() in order to reduce the size and improve the performance of OP_Column. (user: drh, tags: trunk)
17:06
[380a7b7a] Update this branch with the latest changes from trunk. (user: dan, tags: server-process-edition)
16:52
[04e0cb57] Enhance this branch to support page-level-locking (without MVCC) for multi-process deployments. (user: dan, tags: server-process-edition)
14:16
[39543903] Remove an unnecessary local variable from OP_Column, for a small size reduction and performance increase. (user: drh, tags: trunk)
11:04
[dc98a92f] Performance improvement in the OP_Column opcode. (user: drh, tags: trunk)
10:47 • Edit [2cf3f3de8a48465b|2cf3f3de]: Edit check-in comment. (user: drh)
2017-08-15
14:14
[2cf3f3de] Small size and performance improvement in the OP_Column opcode. (user: drh, tags: trunk)
03:46
[373b71d1] Btree optimization: New field BtCursor.pPage that points to the current page, saving a single pointer dereference on each access. (user: drh, tags: trunk)
01:07
[346a710d] Leaf: Fix a problem allowing a conflicting transaction to be committed in the case where more than one 32KB shared-memory page has been written to since the transaction was started. (user: drh, tags: begin-concurrent-branch-3.19)
2017-08-14
23:53
[16969338] Minor size and performance optimization to sqlite3BtreeCloseCursor(). (user: drh, tags: trunk)
18:13
[240d5714] Change the internal btree routine moveToRoot() to return SQLITE_EMPTY if the table is empty or if it has pgnoRoot==0. This simplifies the callers, making them smaller and faster. The SQLITE_EMPTY result code is intercepted and changed into SQLITE_OK before surfacing in an API. (user: drh, tags: trunk)
17:03
[25e92baa] Fix harmless indentation error. (user: drh, tags: trunk)
14:53 • Fixed ticket [aa98619a]: Assertion fault on an IN operator using a constant index plus 5 other changes (user: drh)
14:53
[d0da791b] Sometimes a TK_COLUMN Expr node can have Expr.pTab==0 if it is a reference to an expression column in an index on an expression. Fix for ticket [aa98619ad08ddcab]. (user: drh, tags: trunk)
14:44 • Closed ticket [8897054d]: lsm1 does not overwrite values for duplicate keys plus 5 other changes (user: drh) ... 1 similar event omitted.
12:52 • New ticket [aa98619a] Assertion fault on an IN operator using a constant index. (user: drh)
07:16
[8e1b28ed] Remove code for PLL support in wal mode from this branch. (user: dan, tags: server-process-edition)
06:55
[bc2498d6] Update this branch with latest trunk changes. (user: dan, tags: server-process-edition)
01:33
[7e0d3e9c] Properly dequote column names in tables constructed by an aggregate SELECT. (user: drh, tags: trunk)
2017-08-12
18:31
[02174842] Add new test file fts5vocab2.test. (user: dan, tags: trunk)
14:06
[42560723] Leaf: Add a more rigorous test case for the bug fixed by the previous commit on this branch. (user: dan, tags: begin-concurrent)
02:16
[14d262d6] Update the speed-check.sh test script to append log output to the end of the cout-NAME.txt file. (user: drh, tags: trunk)