aboutsummaryrefslogtreecommitdiff
path: root/src
Commit message (Collapse)AuthorAge
...
| * | Pull in the latest changes from trunk. Update the STAT3 documentation.drh2011-09-21
| |\ \ | | | | | | | | FossilOrigin-Name: 63fc3e4bea6a7f5dc34b2af83f30458eb10b8fe0
| * \ \ Merge in all changes through the 3.7.8 release.drh2011-09-19
| |\ \ \ | | | | | | | | | | FossilOrigin-Name: 9607600b6ca9b546dd248982fd8e8d64f708be5c
| * \ \ \ Merge all the latest trunk changes into the experimental STAT3 branch.drh2011-09-16
| |\ \ \ \ | | | | | | | | | | | | FossilOrigin-Name: 51908c8f2bc6c086570f7493a29b096f0a40ce34
| * \ \ \ \ Merge the latest trunk changes into the stat3-trunk branch.drh2011-09-13
| |\ \ \ \ \ | | | | | | | | | | | | | | FossilOrigin-Name: 11ca4ed8bf850dae1a24b7182f70039f32bd8dd1
| * \ \ \ \ \ Merge the stat3-enhancement branch with trunk, but keep the resulting mergedrh2011-08-26
| |\ \ \ \ \ \ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | in a separate branch for now. FossilOrigin-Name: 63f2c7859fa6e5d0e2cdd218ff52a3ec2d44c61d
| | * | | | | | Fix the stat3 analysis loader to be compatible with sqlite3_db_status().drh2011-08-18
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Also fix some OOM issues with the stat3 analysis loader. FossilOrigin-Name: eaf447ea87b0ff29ae06283204f522fcd005b284
| | * | | | | | Fix a bug in the cleanup of stat tables on a DROP TABLE in autovacuum mode.drh2011-08-18
| | | | | | | | | | | | | | | | | | | | | | | | FossilOrigin-Name: 3fe5d54f635f7b27851d256e417f21b91febb871
| | * | | | | | Fix an error with OOM processing in the ANALYZE logic.drh2011-08-18
| | | | | | | | | | | | | | | | | | | | | | | | FossilOrigin-Name: b26ec79c69f44b55bc4bb11e293f11b3afa3b724
| | * | | | | | Fix a few harmless compiler warnings. Add SQLITE_ENABLE_STAT3 to thedrh2011-08-16
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | standard compiler warning script. FossilOrigin-Name: 3d68f9afee02f95103eb1682b8f2362f8d249437
| | * | | | | | Allow the sqlite3VdbeJumpHere() routine to accept a negative or zero addressdrh2011-08-16
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | if a prior memory allocation error has occurred. The new sqlite_stat3 logic needs this. FossilOrigin-Name: 9650d7962804d61f56cac944ff9bb2c7bc111957
| | * | | | | | Fix a couple of typos in comments in analyze.c.dan2011-08-15
| | | | | | | | | | | | | | | | | | | | | | | | FossilOrigin-Name: ae31dc67aa0637150f964de31a6da6f5797b462a
| | * | | | | | Further testing and bug fixing for sqlite_stat3. Added the Index.avgEqdrh2011-08-13
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | field to index statistics. Fixed several problems in the query planner associated with stat3. FossilOrigin-Name: 89b2f70884cad0abdf4c66cb64ecddb2820ded74
| | * | | | | | Add the sqlite_stat3.nDLT field. Use an linear congruence PRNG to choosedrh2011-08-13
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | which samples to select from among those with the same nEq field. FossilOrigin-Name: 1dcd24283e6c1cc638eb9ffac434046447f88769
| | * | | | | | The ANALYZE command picks for 15 samples for sqlite_stat3 with the largestdrh2011-08-13
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | nEq fields, plus 5 other evenly spaced samples. FossilOrigin-Name: 8225924ea015a0c331b69134139922ec83f989f8
| | * | | | | | Begin a branch that experimentally replaces sqlite_stat2 with a new tabledrh2011-08-12
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | called sqlite_stat3 that will hopefully facilitate better query planning decisions. FossilOrigin-Name: 52e1d7e8ddd4bb5ef3a9d00fd2d719a8a784f807
* | | | | | | | Disable the xfer optimization if "PRAGMA count_changes=1" is configured. ↵dan2011-09-30
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Ticket [c48d99d690]. FossilOrigin-Name: 9ddfe1e41300413bc9af7e5ce0ec9d1daf9136b1
* | | | | | | | In the shell, allow arbitrary table names on the ".import" command.drh2011-09-28
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Ticket [d1d84037b90a449]. FossilOrigin-Name: f4dd32d30ed54f847319664cf749fd0b92b4af3f
* | | | | | | | Enhance the stat VFS to report out the total size of all pages used bydrh2011-09-28
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | a table, even if the ZIPVFS compression backend is in play. Update the sqlite3_analyzer logic to use these new outputs. FossilOrigin-Name: 19b8eaaf70db82d401d33beb7fd36045d5e8326f
* | | | | | | | If an open as read/write fails, do not try to reopen as read-only if indrh2011-09-25
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | exclusive access mode. FossilOrigin-Name: 263c5fb2802f8c84835e42fc66acb1065b7e42b9
* | | | | | | | Add SQLITE_DBSTATUS_CACHE_HIT and _MISS to the ".stat" command in the shell.drh2011-09-23
| |_|_|_|_|_|/ |/| | | | | | | | | | | | | FossilOrigin-Name: d279e1a309909a0897b6082753a0fadb5066c31a
* | | | | | | Remove the SQLITE_PAGECACHE_BLOCKALLOC compilation option.dan2011-09-22
| | | | | | | | | | | | | | | | | | | | | FossilOrigin-Name: 4eb4689834b538b9eeec5a5803528260e1aff78d
* | | | | | | Add the SQLITE_DB_STATUS_CACHE_HIT and MISS options. For querying the number ↵dan2011-09-22
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | of cache hits and misses on a per-connection basis. FossilOrigin-Name: 5100b6e9dc5107f0f835d0aac26fe6d4938ffc73
* | | | | | | Change the way the sqlite3_analyzer executable is built.dan2011-09-21
| |_|_|_|_|/ |/| | | | | | | | | | | FossilOrigin-Name: 05e3cced8a884e8bca6f208d2f09e335d3929eac
* | | | | | Minor comment change in the description of the different memory allocatordrh2011-09-19
| |_|_|_|/ |/| | | | | | | | | | | | | | | | | | | options. No changes to code. FossilOrigin-Name: 36be31ff0af7f811fe2c6f7e26f058cffb7257e1
* | | | | Increase the default lookaside cache line size from 100 to 128 bytes.drh2011-09-19
| | | | | | | | | | | | | | | FossilOrigin-Name: db019465036171fcad31181bec7d6ac185f50430
* | | | | Remove a stray merge-sort related change from pager.c and pager.h.dan2011-09-19
| | | | | | | | | | | | | | | FossilOrigin-Name: 69823ed163049d6fa1e24a9810c3c99f2a8fdd46
* | | | | Make sure the file structure is zeroed prior to calling the VFS to open a file.mistachkin2011-09-17
| | | | | | | | | | | | | | | FossilOrigin-Name: 29c4d0dd43d41650e54824afd70dd40f1b91cc86
* | | | | Fix a problem with SQLITE_OMIT_TRACE that was introduced by the recentdrh2011-09-16
| | | | | | | | | | | | | | | | | | | | | | | | | OP_Once change. FossilOrigin-Name: 96be3f7b59b3ed4703b907e29db629df34b2b56f
* | | | | Fix #if's in winSync to avoid compiler warnings about unused local ↵mistachkin2011-09-16
| | | | | | | | | | | | | | | | | | | | | | | | | variables. Also, update version numbers in the MSVC makefile. FossilOrigin-Name: 2e66e41457422449ac5918b16be443e737dfb149
* | | | | Silence harmless compiler warning about redefinition of the ↵mistachkin2011-09-16
| |_|_|/ |/| | | | | | | | | | | | | | | _CRT_SECURE_NO_WARNINGS macro by shell.c. FossilOrigin-Name: 690220717f3d92d4fb7bd72226fc8d5f38f5fbcf
* | | | Remove unreachable branches from the previous change. Add additionaldrh2011-09-16
| | | | | | | | | | | | | | | | | | | | test cases. FossilOrigin-Name: cf51ef8ab8a610ddf64f66970dd689fe1df405b8
* | | | When analyzing the right-hand side of IN operators to see if the IN operatordrh2011-09-16
| | | | | | | | | | | | | | | | | | | | | | | | can work with an index, be sure to decend into nested subqueries. Fix for ticket [1a1308d2538d7] FossilOrigin-Name: 0156f10e23daca0e2504cd293a67ed0233d254d0
* | | | Further streamlining of the subquery materializer. New test cases fordrh2011-09-16
| | | | | | | | | | | | | | | | | | | | ticket [002caede898a] FossilOrigin-Name: ff8b76b25b42497a7374de56c6a8f34cbe70cd6a
* | | | Add the new OP_Once opcode. Use it to clean up and simplify variousdrh2011-09-16
| | | | | | | | | | | | | | | | | | | | | | | | one-time initialization sections in the code, including the fix for ticket [002caede898ae]. FossilOrigin-Name: 7f00552b739fad79517b042a6ed61abe743a917b
* | | | Materialize subqueries using a subroutine and invoke that subroutinedrh2011-09-15
| | | | | | | | | | | | | | | | | | | | | | | | prior to each use of the subqueries manifestation. Fix for ticket [002caede898aee4] FossilOrigin-Name: 4b8357ee3c4ccdbd34e0cd077efd84cca677f496
* | | | Remove 'const' from a variable that might actually be written when an OOM ↵mistachkin2011-09-14
| | | | | | | | | | | | | | | | | | | | error occurs. Also, fix a couple MSVC/Win32 compiler warnings. FossilOrigin-Name: 3035dc1c7398791d550f4c02774ef7f961b4bb02
* | | | Remove unused parameters from internal routines in vdbesort.c. This isdrh2011-09-14
| | | | | | | | | | | | | | | | | | | | an additional simplification made possible by recent optimizations. FossilOrigin-Name: a1f3aeeb0988c848d40ce8f6da6e902935a997e2
* | | | Remove code from vdbesort.c that was made unreachable by the recentdrh2011-09-14
| |_|/ |/| | | | | | | | | | | sqlite3VdbeRecordUnpack() optimizations. FossilOrigin-Name: 607aba6cd7020973200fa376cf8df55360165266
* | | Fix a minor performance regression in btreeMoveto().dan2011-09-05
| | | | | | | | | FossilOrigin-Name: d0712dfb24867a807c9cddcc12bd0aebe1d3e085
* | | Refactor the sqlite3VdbeRecordUnpack() interface to better accommodate the ↵dan2011-09-05
| | | | | | | | | | | | | | | vdbesort.c module. FossilOrigin-Name: f115b2303509c678dbe83b2fa3d9c40d82882813
* | | Fix a compiler warning about an unused parameter in the merge-sort code.drh2011-09-04
| | | | | | | | | FossilOrigin-Name: 6b657ae75035eb10b0ad640998d3c9eadfdffa6e
* | | Improve the testability of the merge-sort logic.drh2011-09-04
| | | | | | | | | FossilOrigin-Name: b5179baf87aa00ed5cecbdcaa65bee10e112a9e9
* | | Performance improvements to the external merge-sorter. Keep content on andrh2011-09-03
|\ \ \ | | | | | | | | | | | | | | | | | | | | | | | | in-memory linked lists rather than an ephemeral table prior to spilling to disk. Use the external merge-sorter to implement ORDER BY and GROUP BY in addition to CREATE INDEX. FossilOrigin-Name: 4c43e8b2d2c1d8dcba3cd1c3f2ec4e19ab419430
| * | | Simplification and performance tweaks in vdbeSorterMerge().drh2011-09-03
| | | | | | | | | | | | FossilOrigin-Name: 99e34bdce4ccca15b79159b03b96787e7a7ff85b
| * | | Reduce the number of VdbeRecordUnpack() calls made in vdbesort.c.dan2011-09-03
| | | | | | | | | | | | FossilOrigin-Name: 666c2c3cff51dac2ba5689b75705d99c3705673b
| * | | The build works again with -DSQLITE_OMIT_MERGE_SORT. The merge-sorter nowdrh2011-09-03
| | | | | | | | | | | | | | | | | | | | | | | | avoids spilling to disk (letting the in-memory linked list grow without bound) if PRAGMA temp_store=3. FossilOrigin-Name: 68e26c4487696d194ee85370380e4b0e56d206ee
| * | | Remove some dead code. Fix a faulty assert(). Improve some variable names.drh2011-09-02
| | | | | | | | | | | | FossilOrigin-Name: a9a64592cf88580cb254fb0aac65a2f2085976ec
| * | | Combine two malloc calls in vdbesort.c.dan2011-09-02
| | | | | | | | | | | | FossilOrigin-Name: cf48ad8353e28339d00f448bb729e10a7f2aad72
| * | | Reduce the number of malloc() calls made when creating an index on more than ↵dan2011-09-02
| | | | | | | | | | | | | | | | | | | | 2 columns. FossilOrigin-Name: 065b0c9858da0ebb41722f3c56bdaf62f28b2f2c
| * | | If all data being sorted fits in memory, avoid writing any data out to ↵dan2011-09-02
| | | | | | | | | | | | | | | | | | | | temporary files in vdbesort.c. FossilOrigin-Name: 71075673c625f243969c3f34c73f28f378924007