SQLite
Timeline
Not logged in

30 ancestors of [72727b68cd]


2014-09-19
02:01
[72727b68cd] Leaf: Make sure that the sorting-index pre-filter recognizes that a rowid reference might be sortable. This fixes a performance regression. (user: drh, tags: trunk)

00:43
[5b9b898779] Add the sqlite3VdbeMemClearAndResize() interface to be used in place of sqlite3VdbeMemGrow(). (user: drh, tags: trunk)
2014-09-18
21:25
[9c09ac353d] Add the Mem.szMalloc element to the Mem object and use it to keep track of the size of the Mem.zMalloc allocation. (user: drh, tags: trunk)
18:55
[55879932116d] Correct typos in comments. No changes to code. (user: mistachkin, tags: trunk)
17:52
[4c8c89d7e6] Merge the Mem.r value into the MemValue union as Mem.u.r. Hence, a Mem can now store an integer or a real but not both at the same time. Strings are still stored in a separate element Mem.z, for now. (user: drh, tags: trunk)
16:28
[d7afdcbac2] Performance improvement for affinity transformations on comparison operators. (user: drh, tags: trunk)
14:36
[4ef4c9a7c8] Since numeric affinity is the most common case, check it first. Interchange the NONE and TEXT affinity codes for easier checking of no affinity. (user: drh, tags: trunk)
09:59
[3bd7c1b2fa] Modify an assert() within sqlite3PagerWalFramesize(), a function only ever used by zipvfs, to account for recent zipvfs changes. (user: dan, tags: trunk)
02:20
[5192f964b2] Fix harmless warnings on 32-bit MSVC builds. (user: drh, tags: trunk)
01:50
[ef1aa10b7f] Make sure of the strchrnul() library function on platforms where it is available. (user: drh, tags: trunk)
01:29
[1de558bcb1] Merge micro-optimizations into trunk after fixing the build on MSVC. Performance now shows 7.58% faster than the 3.8.6 release on x64 with gcc 4.8.1 and -Os. (user: drh, tags: trunk)
01:21
[163bfae858] Closed-Leaf: Fix compiler warnings and change the nullMem structure initializer into a format that MSVC can understand. (user: drh, tags: micro-optimizations)
2014-09-17
23:37
[14052a7d08] Performance improvement and slight size reduction to the comparison operators in the VDBE. (user: drh, tags: micro-optimizations)
16:41
[fdddb477c8] In the Mem object, stop requiring that Mem.xDel be NULL when the MEM_Dyn bit is clear. Also reduce the amount of initialization of Mem objects. All for a small size reduction and performance increase. (user: drh, tags: micro-optimizations)
14:52
[4e43784432] Improved interface to the Mem object handling. Small size reduction and performance increase. (user: drh, tags: micro-optimizations)
2014-09-16
21:54
[2598aedc5d] Continuing cleanup of memory register memory allocation handling. (user: drh, tags: micro-optimizations)
20:05
[78fb8838d8] Make sure registers are cleared properly prior to being used to store the result of an OP_Column operator. (user: drh, tags: micro-optimizations)
18:22
[f73678038d] Simplification of the OP_Column logic for the case of rows with overflow. (user: drh, tags: micro-optimizations)
14:55
[a10a6bba49] Remove an unused parameter from sqlite3VdbeIdxRowid(). This is cosmetic only as the C-compiler optimizers were already omitting this parameter on amalgamation builds. (user: drh, tags: micro-optimizations)
14:37
[8239c35aed] Reduce the number of arguments to RecordCompare functions from 4 to 3, resulting in a small performance increase. (user: drh, tags: micro-optimizations)
14:16
[0be3019ed7] Reorder the elements of the Mem object for a small size reduction and performance improvement. Moved into a branch because MSVC is unable to handle named structure initializer on nullMem. (user: drh, tags: micro-optimizations)
13:30
[8fb90da77c] Changes to sqlite3VdbeRecordUnpack() to make it slightly smaller and faster. (user: drh, tags: trunk)
03:24
[20ed2321b0] Performance improvement to the sqlite3MemCompare() routine by factoring out sqlite3BlobCompare(). (user: drh, tags: trunk)
2014-09-15
16:53
[4060efb646] Fix tool/showwal.c so that it handles WAL files that contain 64KiB pages. (user: dan, tags: trunk)
16:50
[dedaa6fb3d] Avoid attempting to call the xFetch() method of an sqlite3_io_methods object with a version number less than 3. (user: dan, tags: trunk)
14:59
[69a6456077] Remove the EXPENSIVE_ASSERTS in pcache.c having to do with the pSynced field of the Pcache object, as they are incorrect, as revealed by recent pcache enhancements. (user: drh, tags: trunk)
14:46
[0bdf1a086b] Do not flatten aggregate subqueries that contain min() or max() functions so that if the min()/max() are discarded by the outer query, they still function and cause non-aggregate expression to be evaluated on the minimal or maximal row. (user: drh, tags: trunk)
11:14
[4ff0eb96bc] Adjust comments to show that subquery flattening restriction (10) was removed from the code back in 2005. This is a comment change only. (user: drh, tags: trunk)
2014-09-12
20:30
[b332a84d51] Small performance improvement to the dirty list handling in the pager. (user: drh, tags: trunk)
17:41
[320556233e] Simplify the way the column cache is managed around OP_Move instructions. (user: drh, tags: trunk)
04:28
[2f69a1fa6a] Fix a problem with parser memory allocation on 32-bit systems. (user: drh, tags: trunk)