SQLite
Timeline
Not logged in

30 ancestors of [3e922208b6]


2014-10-21
21:56
[3e922208b6] Leaf: Call fsync() right after ftruncate() when in journal_mode=TRUNCATE and when synchronous=FULL in order to ensure that transactions are durable across a power loss that happens moments after the commit. Proposed fix for https://bugzilla.mozilla.org/show_bug.cgi?id=1072773. (user: drh, tags: trunk)

18:16
[a27861c28c] Further tuning of the cost estimates for skip-scan loops, especially for cases when skip-scan loops are in competition with regular loops. (user: drh, tags: trunk)
16:01
[ec1e942f08] Add WHERETRACE debugging output to the whereLoopAdjustCost() routine. (user: drh, tags: trunk)
01:05
[f4b22a2620] If a skip-scan is a proper subset of some other scan, then adjust the cost of the skip-scan upward so that it is more costly than the other scan. Such a cost imbalance can arise under STAT4 because of difficulties in getting an accurate estimate for skip-scans. (user: drh, tags: trunk)
2014-10-17
21:35
[19fe4a0a47] Fix a (probably harmless) bug in the CSV output mode of the command-line shell. (user: drh, tags: trunk)
11:24
[e4ab094f8a] Version 3.8.7 (user: drh, tags: trunk, release, version-3.8.7)
2014-10-16
21:39
[06c576c152] Work around MSVC not being able to deduce that a local variable was initialized in a called function. (user: mistachkin, tags: trunk)
18:34
[1418c006e3] Changes to work around Win32 and MSVCRT APIs that are not present on Windows CE 200x. (user: mistachkin, tags: trunk)
11:45
[640345d880] Update the vdbe-compress.tcl script to account for expressions of the form (123>var), where "var" should be replaced with a reference to a union member. (user: dan, tags: trunk)
2014-10-15
15:28
[3c1e70f4d5] Update releasetest.tcl so that x86-64 runs a superset of the x86 tests. (user: dan, tags: trunk)
14:45
[b3e7b446bd] Fix a problem causing lock5.test to fail in mmap-mode. (user: dan, tags: trunk)
11:55
[9386bfca12] Add a four-byte prefix to the BtShared.pTmpSpace buffer to avoid reading before the beginning of an allocation. (user: drh, tags: trunk)
11:31
[4a7b3fa049] Rearrange an expression in vdbemem.c to avoid a (harmless) reference to a possibly unitialized variable. (user: dan, tags: trunk)
2014-10-14
20:25
[eab8233063] Make sure new sqlite3_vtab objects created by the xCreate() virtual table method are initialized by the system, in accordance with the documentation. (user: drh, tags: trunk)
2014-10-13
23:39
[005e5b388a] Optimize a database corruption test inside of the OP_Column opcode. (user: drh, tags: trunk)
20:12
[4b3b65ee5e] Use the padding word in the Mem object as temporary storage for serial_type value in OP_Record, and thus avoid a redundant computation of the serial_type for each column. (user: drh, tags: trunk)
17:42
[04892f8ba6] Three small optimizations to vdbeaux.c. (user: drh, tags: trunk)
16:02
[c2799aece1] Reduce the CPU load imposed by sqlit3VdbeCursorMoveto() by factoring out some of its functions and by avoiding unnecessary calls. (user: drh, tags: trunk)
13:00
[20062f4942] Remove the OPFLAG_CLEARCACHE flag from OP_Column. In its place, change the P3 parameter of OP_SorterData to be the index of the pseudo-table cursor whose record header cache is to be cleared. This gives a small size reduction and performance increase. (user: drh, tags: trunk)
2014-10-12
22:37
[91384a7d72] Remove the VdbeCursor.lastRowid cache of the current rowid, since maintaining the correct cache value uses more CPU cycles than just recomputing the rowid on the occasions when it is actually needed. Replace it with the VdbeCursor.aOffset field which used to be computed from VdbeCursor.aType when needed. Saves 100 bytes of code space and runs 0.2% faster. (user: drh, tags: trunk)
2014-10-11
23:31
[869c30e45c] Performance optimization and very slight size reduction for OP_Column. (user: drh, tags: trunk)
17:22
[66de15580d] Simplification to the insertCell() routine in btree.c, resulting in a performance boost and a very small size decrease. It turns out that the extra work involved in sometimes avoiding an memcpy() of the first four bytes of a record takes more time than just unconditionally copying those four bytes. (user: drh, tags: trunk)
10:52
[5d29a033b0] Require the SQLITE_ENABLE_RTREE compile-time option in speedtest1.c in order to enable the R-Tree tests. (user: drh, tags: trunk)
02:12
[7a32fdfd4b] Make sure that a GROUP BY that also implements an ORDER BY scans the table in the correct order. Fix for ticket [ba7cbfaedc7e6]. (user: drh, tags: trunk)
01:22
[c5dc83ebde] Remove an unnecessary conditional from the EXPLAIN QUERY PLAN logic. (user: drh, tags: trunk)
2014-10-10
20:52
[2a9573962b] Closed-Leaf: Account for the ASC/DESC properties of ORDER BY expressions when using the same index for GROUP BY and ORDER BY. Candidate fix for [ba7cbfaedc]. (user: dan, tags: experimental)
19:15
[c301245200] Restrict the scope of the explainIndexRange() function in where.c. (user: drh, tags: trunk)
19:10
[8541dfb3bb] Fix a failing test case in index5.test. Also tweak the way cache memory is divided between read-only and dirty pages when using SQLITE_CONFIG_PAGECACHE to reduce IO in some cases. (user: dan, tags: trunk)
18:09
[9ee5686ab3] Changes to enable compiling using VC6. (user: drh, tags: trunk)
17:47
[cf291cbe9f] When using the -config option to releasetest.tcl, default the testing type to "fulltest" if it is not specified on the command line. (user: drh, tags: trunk)
17:44
[d479e32be2] Provide the new "-config CONFIG" option to the test/releasetest.tcl script, which allows one to run a single test configuration selected by name. (user: drh, tags: trunk)