SQLite
Timeline
Not logged in

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

50 most recent timeline items

2016-05-24
00:40
[3b28b68e23] Leaf: Improvements to the initialization of the push-down automoton for the Lemon-generated parser. Smaller and faster. (user: drh, tags: trunk)
2016-05-23
21:56
[3c2a770549] Use a pointer to the top of the stack rather than an index into the stack in the Lemon-generated parser template, for about 6.6% parser performance gain. (user: drh, tags: trunk)
19:02
[276e92f5b4] Avoid a minor error message when running RTREE without an sqlite_stat1 table. (user: drh, tags: trunk)
18:27
[9589e93771] Closed-Leaf: Fix the rtreeG.test test case. (user: drh, tags: tree-stat1-fix)
18:15 • Edit [bfbb6dd84b5e1335|bfbb6dd84b]: Move to branch tree-stat1-fix... (user: drh)
18:12
[48526a2fe5] Fix RTREE so that it does not run queries against the sqlite_stat1 if that table does not exist. (user: drh, tags: tree-stat1-fix)
18:06
[bfbb6dd84b] Remove an extra "finish_test" from the end of rtreeC.test. (user: drh, tags: tree-stat1-fix)
16:16
[3ad2531efb] Improve the error messages generated by the rtree module when a constraint fails. (user: dan, tags: trunk)
16:15
[a86e782ad1] Lemon enhancement: avoid unnecessary reduce actions that convert one non-terminal into another but have no side effects. (user: drh, tags: trunk)
14:24
[b91a5b8297] Fix comment typos and improve clarity of presention in Lemon. The output should be identical. (user: drh, tags: trunk)
02:57
[815cc2bb48] Leaf: Merge changes from trunk. (user: drh, tags: apple-osx)
00:10
[90411a2816] Update the configure script with additional hints on the location of tclConfig.sh, hints needed by the latest versions of Xcode. (user: drh, tags: trunk)
2016-05-21
23:25
[dec1307581] More tweaks to improve the performance of the insert logic, slightly. (user: drh, tags: trunk)
20:03
[55f348cdd2] Simplify the sqlite3BtreeInsert() interface by gathering the five arguments describing the content to be inserted into the new BtreePayload structure, and thus reducing the number of parameters from eight to four. (user: drh, tags: trunk)
19:10
[2ce1166717] Remove some unused legacy code from the btree insert logic. (user: drh, tags: trunk)
18:50
[f33aa76f07] Leaf: Use pthreads mutexes and conditions to synchronize threads in bc_test1. (user: dan, tags: begin-concurrent)
12:29
[1dbaf7a119] Yet another minor size reduction and performance increase in the b-tree insert logic. (user: drh, tags: trunk)
11:23
[656aa1ecf5] Small size reduction and performance increase in the sqlite3BtreeInsert() logic. (user: drh, tags: trunk)
00:45
[8e366f18f5] Add the shell-script used for routine performance testing. (user: drh, tags: trunk)
2016-05-20
23:51
[96cf821b6a] Add a simple TCL script for summing cachegrind information for each VDBE opcdoe. (user: drh, tags: trunk)
21:40
[1765672c25] Another optimization on the OP_Column opcode. (user: drh, tags: trunk)
20:58
[9db8f21473] Fix typo in comment. (user: mistachkin, tags: trunk)
19:51
[5c15747439] Slight performance improvement in the OP_Column opcode. (user: drh, tags: trunk)
18:09
[f250166bb3] Remove the sqlite3PagerClearCache() routine, which does not accomplish anything useful. (user: drh, tags: trunk)
15:53
[4dc56e8684] Performance optimization and size reduction on the freeP4() routine. (user: drh, tags: trunk)
15:24
[1a0d05765f] Increase the version number to 3.14.0 since we are already making significant code changes. (user: drh, tags: trunk)
15:15
[3d55d24dcb] Use sqlite3VdbeAddOp0() to code OP_Expire, to save a few bytes. (user: drh, tags: trunk)
14:54
[9033afbb31] Optimizations to link list merge sort code in vdbesort.c, pcache.c, and rowset.c. Resulting binaries are 10 bytes smaller and use 0.03% fewer CPU cycles. (user: drh, tags: trunk)
14:11
[559733b09e] For queries with both ORDER BY and LIMIT, if the rows of the inner loop are emitted in ORDER BY order and the LIMIT has been reached, then optimize by exiting the inner loop and continuing with the next cycle of the first outer loop. (user: drh, tags: trunk)
13:44
[ed1b30dc93] Closed-Leaf: Set the NULLEQ flag on the sequence counter comparison in the ORDER BY LIMIT optimization, to avoid coverage complaints about not testing the NULL case. (user: drh, tags: orderby-limit)
12:22
[645bd696df] Autoconf configure.ac adjustment to try to get it to look for both editline and readline automatically. (user: drh, tags: trunk)
00:21
[08849eab0f] A few simple test cases for the ORDER BY LIMIT optimization. (user: drh, tags: orderby-limit)
2016-05-19
22:40
[990fe50c91] Appears to work now. Needs test cases, more comments, and code optimization. (user: drh, tags: orderby-limit)
22:13
[852d1eda6e] In a query with both ORDER BY and LIMIT, if the inner loop satisfies the ORDER BY then try to cut short each invocation of the inner loop once the LIMIT has been satisfied. This check-in is a partial implementation only. (user: drh, tags: orderby-limit)
19:31
[58b516e8c0] Fixup comments on wctrlFlags value definitions. (user: drh, tags: trunk)
18:56
[d01305841d] Clean up the WHERE_* macros used for the wctrlFlags parameter on the sqlite3WhereBegin() interface, freeing up some bits to be used for other things. (user: drh, tags: trunk)
17:51
[cf2737415a] Optimization marks in vdbe.c. No logic changes. (user: drh, tags: trunk)
16:58
[4737cadc41] Performance improvement in the OP_Column opcode. (user: drh, tags: trunk)
16:21
[1f577e1f08] Add test cases to test some fts3/4 edge case behaviour surrounding the '*' character. (user: dan, tags: trunk)
11:12
[0d7730611b] Small size reduction and performance improvement in the OP_Column opcode. (user: drh, tags: trunk)
2016-05-18
21:03
[c981ab2a47] Add the "scrub" utility program that simultaneously backs-up a live database and erases all deleted content. (user: drh, tags: trunk)
21:01
[915416d15f] Omit the unnecessary WHERE_REOPEN_IDX flag in the WHERE interface. (user: drh, tags: trunk)
20:53
[e2e9b98556] Merge the 3.13.0 release changes. (user: drh, tags: apple-osx)
10:57
[fc49f556e4] Version 3.13.0 (user: drh, tags: trunk, release, version-3.13.0)
2016-05-17
21:17
[ab1c5ce50f] Closed-Leaf: Enhance the scrub utility program so that it does a FULL checkpoint prior to starting the backup, to ensure that the database file content matches what needs to be backed up without having to look at the WAL file. (user: drh, tags: scrub-backup)
17:11
[5021dfe1f3] Merge the latest changes from trunk. (user: drh, tags: scrub-backup)
2016-05-16
14:35
[995c084bde] Do not run snapshot_fault.test as part of the inmemory_journal permutation. (user: dan, tags: trunk)
13:37
[0d9b82afea] Merge recent fixes from trunk. (user: drh, tags: apple-osx)
11:55
[386bcbba8e] Disable shell.exe test cases for UTF8 filenames as they do not work on MinGW. (user: drh, tags: trunk)
2016-05-13
17:22
[b369980f0c] Improvements to a comment in the pcache.c file. No changes to code. (user: drh, tags: trunk)