/ Timeline
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

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

42 check-ins using file src/pager.c version 47343e34

2009-11-20
05:05
Improve comments and other things in fts3_write.c. check-in: 1cf0e3cc user: dan tags: trunk
02:24
Minor optimizations to fts3 code. check-in: b456eacb user: dan tags: trunk
2009-11-19
18:30
Merge leaves [7cd178a72a] and [598727e6da]. check-in: 4115c0c2 user: dan tags: trunk
18:28
Fix a performance regression introduced while reworking the fts3 code. check-in: 7cd178a7 user: dan tags: trunk
15:44
Remove an unreachable branch from the OP_Affinity suppression logic. check-in: 598727e6 user: drh tags: trunk
15:26
Merge fts3-refactor into the main trunk. check-in: 551dbe30 user: dan tags: trunk
15:25
Fix some fts3 related issues with the autoconf and amalgamation build systems. Closed-Leaf check-in: 3b179247 user: dan
14:57
Merge with [4bd4330709]. check-in: 7a46d1eb user: dan tags: fts3-refactor
14:52
Merge the fts3-refactor branch with the trunk. check-in: c8d2bd37 user: dan tags: fts3-refactor
14:48
Fix a bug introduced with recent optimizations: The unary minus operator is TK_UMINUS, not TK_MINUS. check-in: 4bd43307 user: drh tags: trunk
00:15
Fix problems introduced into fts3 as part of the refactoring. check-in: fa0998e1 user: dan tags: fts3-refactor
2009-11-18
23:01
Performance improvement by avoiding unnecessary calls to memset(). check-in: 85940468 user: drh tags: trunk
15:35
Add some missing comments and fix some other issues in fts3 code. check-in: 2fe579e7 user: dan tags: fts3-refactor
01:25
Suppress more instances of unnecessary OP_IsNull and OP_Affinity opcodes. check-in: bf6c0bd1 user: drh tags: trunk
2009-11-17
23:59
Enhancements to the VDBE opcode loop to reduce the number of machine-code instructions evaluated by about 10%. check-in: 9744ffb3 user: drh tags: trunk
18:31
Code generator tries to avoid pointless OP_IsNull and OP_Affinity opcodes. check-in: ebb0c8a3 user: drh tags: trunk
12:52
Improvements to the way fts3 reads the full-text index. check-in: 45c051e7 user: dan tags: fts3-refactor
2009-11-16
23:36
Make sure the output of sqlite3OsFullPathname is initialized even if the fails due to I/O or OOM errors. check-in: e4943adb user: drh tags: trunk
22:54
Fix a reference to freed memory that can occur following an OOM error in where.c. check-in: 929b6047 user: drh tags: trunk
21:28
Back out part of the change in [23ea2b700fd6d28d] since TH3 reveals some problems in OOM situations. check-in: 15d215d6 user: drh tags: trunk
16:36
Add a few extra coverage test cases for fts3. check-in: f29c8fca user: dan tags: fts3-refactor
15:11
Use the sqlite3CtypeMap to improve the speed and reduce the size of the logic in the tokenizer that recognizes identifiers. check-in: 1c9243b0 user: drh tags: trunk
03:13
Additional optimizations in sqlite3VdbeRecordCompare(). check-in: 23ea2b70 user: drh tags: trunk
02:14
Optimizations to the sqlite3VdbeRecordCompare() routine help it to run 12.5% faster for some traces. check-in: 74c76f0b user: drh tags: trunk
2009-11-15
06:50
Fixes to fts3 integrity check code. check-in: d3cae986 user: dan tags: fts3-refactor
2009-11-14
23:22
Optimizations to the main loop inside sqlite3VdbeExec() to help VDBE byte code run a few percent faster. check-in: d622ac6a user: drh tags: trunk
18:41
Further OOM testing for fts3 code. Add Tcl code implementing an integrity-check for fts3. check-in: c27d46b3 user: dan tags: fts3-refactor
18:04
Make the sqlite3VdbeExec() function about 2% faster by storing the opcode array in a local variable. check-in: 8bd3cc82 user: drh tags: trunk
2009-11-13
20:52
Performance improvements and size reductions on the OP_Seek* family of VDBE opcodes. check-in: ed820f45 user: drh tags: trunk
19:43
Simplify the OPFLG processing logic in the VDBE for a speed boost in the VDBE processing loop and a reduction in code size. check-in: 3352b3eb user: drh tags: trunk
17:36
Start reworking fts3 code to match the rest of SQLite (code conventions, malloc-failure handling etc.). check-in: 30a92f11 user: dan tags: fts3-refactor
17:05
Force 8-byte memory alignment on memory allocated for VDBE cursors. check-in: bdc45ba7 user: drh tags: trunk
10:04
Changes to test_intarray.c so that it build with SQLITE_OMIT_VIRTUALTABLE. Added testcase() macros to expr.c. check-in: f0599d28 user: drh tags: trunk
2009-11-12
20:39
Shift more OP_Found opcodes over to using the unpacked format, for improved performance. check-in: 6705ab1a user: drh tags: trunk
19:59
Enhance the OP_Found and OP_NotFound opcodes so that they can accept an array of registers as an unpacked record in addition to a record built using OP_MakeRecord. Use this to avoid OP_MakeRecord calls during IN expression processing. check-in: b9eab885 user: drh tags: trunk
17:52
Factor out the IN operator code generation into a subroutine. Use this subroutine to implement both logic and branching versions of the IN operator. check-in: fcff5b7e user: drh tags: trunk
13:32
Factor out the code generator for BETWEEN into a subroutine. check-in: 5735f60b user: drh tags: trunk
05:04
Update comment for substrFunc(). Added additional SUBSTR() test cases. check-in: d7b3801d user: shaneh tags: trunk
04:26
Suppress unnecessary OP_Noop instructions on when the right table of a LEFT JOIN uses the index-only optimization. check-in: e8aec08b user: drh tags: trunk
03:46
Suppress excess OP_Null opcodes caused by binary IS or IS NOT operators that are converted into unary ISNULL or NOTNULL operators. check-in: cff1b36a user: drh tags: trunk
03:13
Adjustments to the implementation of LIMIT so that it uses fewer opcodes. check-in: 39d5b292 user: drh tags: trunk
2009-11-11
23:58
If the sector size is unspecified (initially 0) then set it to 512, not to 32. check-in: 8861b5c1 user: drh tags: trunk