/ Timeline
Login

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

52 check-ins using file src/pcache1.c version db4a996e

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)
23:48
Remove an obsolete (and incorrect) comment from sqlite3MemCompare(). No changes to code. (check-in: c15b70b3 user: drh tags: trunk)
20:53
Tweaks to the SUBSTR() function to make it dramatically faster in the common case where the input string is large but the 2nd and 3rd arguments are small positive integers. (check-in: 5a474a86 user: drh tags: trunk)
13:17
Allow media sector sizes as small as 32. The former minimum size was 512. (check-in: 5a32bfc1 user: drh tags: trunk)
04:17
Modified CLI to raise an error when extra command line options are passed. Added tests to verify correct handling, as well as other basic handling of command line options. Ticket [f5cb008a65]. (check-in: 09b4f19f user: shaneh tags: trunk)
01:14
Additional test cases for the coalesce() and ifnull() functions. (check-in: d0591258 user: drh tags: trunk)
00:24
Generate VDBE code for the built-in COALESCE() and IFNULL() functions. This allows unused arguments to never be evaluated, which is a performance win when the unused argument is a subquery. (check-in: 30055b25 user: drh tags: trunk)
2009-11-10
17:55
Additional intarray test cases and tweaks to comments. (check-in: 0c8db5d8 user: drh tags: trunk)
17:24
Initial implementation and test cases for the "intarray" virtual table. (check-in: 0e7d2925 user: drh tags: trunk)
17:07
Fix for datbase name being ignored with the -batch option in the CLI. Ticket [aeff892c57]. (check-in: 8097c64a user: shaneh tags: trunk)
01:30
Remove the obsolete "$Id:$" RCS identifier strings from the source code. (check-in: f6c045f6 user: drh tags: trunk)