Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History of tool/spaceanal.tcl
|
2017-10-31
| ||
| 14:56 | Update the built procedures for the sqlite3_analyzer utility to allow it to be linked with an external sqlite3.o library. Automatically detect a missing dbstat extension and report the compile-time error. file: [4bfd19aa] check-in: [bb39744f] user: drh branch: trunk, size: 30216 | |
|
2017-06-15
| ||
| 16:45 | Fix typo and improve the wording of the description of "Metadata" in the output of the sqlite3_analyzer tool. file: [f40dc82b] check-in: [ca1ff707] user: drh branch: trunk, size: 29766 | |
| 00:52 | Enhance the sqlite3_analyzer.exe utility so that it computes and shows the number of bytes of metadata on btree pages and per table and index entry. file: [a91e09e9] check-in: [43ad41ef] user: drh branch: trunk, size: 29703 | |
|
2016-10-12
| ||
| 18:26 | Add to sqlite3_analyzer command-line options --version and --tclsh, and also the undocumented --debug option. file: [ab7d9bf6] check-in: [e87d02d2] user: drh branch: trunk, size: 28864 | |
|
2016-05-06
| ||
| 15:16 | Fix a bug in sqlite_analyzer causing it report (slightly) incorrect values for the number of entries in indexes or WITHOUT ROWID tables. file: [85d90e66] check-in: [dc37750d] user: dan branch: trunk, size: 27711 | |
|
2015-09-08
| ||
| 17:31 | Fix the help message that sqlite3_analyzer.exe generates for invalid arguments. file: [93c1fdc9] check-in: [33a14e7b] user: drh branch: trunk, size: 27565 | |
|
2015-08-04
| ||
| 19:06 | Improve the usage comment on sqlite3_analyzer: show the available switches. file: [63a41538] check-in: [783f78e3] user: drh branch: trunk, size: 27121 | |
| 14:18 | In the sqlite3_analyzer.exe utility, show the depth of each btree and report the average fanout of indexes and WITHOUT ROWID tables. file: [ac584838] check-in: [cd997770] user: drh branch: trunk, size: 27096 | |
|
2015-05-11
| ||
| 17:46 | Test cases for sqlite3_analyzer and sqldiff. Fix a problem with sqlite3_analyzer related to the renaming of the initialization routine. file: [713c587a] check-in: [85a4a46c] user: drh branch: trunk, size: 27317 | |
|
2015-02-09
| ||
| 17:46 | Fix WITHOUT ROWID table handing in sqlite3_analyzer. file: [d5a09620] check-in: [937e0fe7] user: dan branch: trunk, size: 27341 | |
|
2013-11-02
| ||
| 11:43 | Import the sqlite3_analyzer fixes from trunk. file: [8e50b217] check-in: [ac711459] user: drh branch: omit-rowid, size: 26820 | |
| 11:34 | A pair of sqlite3_analyzer bug fixes: (1) quote strings in the SQL at the end of the output. (2) Fix test_stat.c so that it no longer misses some overflow pages on internal index pages. file: [81fad690] check-in: [42a11e74] user: drh branch: trunk, size: 26822 | |
|
2013-11-01
| ||
| 20:30 | Fix sqlite3_analyzer so that it works with WITHOUT ROWID tables. Fix index generation for secondary indices that include fields from the PRIMARY KEY. file: [00023972] check-in: [f9769d70] user: drh branch: omit-rowid, size: 26818 | |
|
2013-09-28
| ||
| 12:40 | Updates to the sqlite3_analyzer utility: Change the names of some labels, especially change "Fragmentation" to "Non-sequential pages". Revise the computation of non-sequential pages so that it ignores itercalated non-leaf pages (overflow and index pages). file: [d8c11da1] check-in: [3e5c7771] user: drh branch: trunk, size: 26820 | |
|
2013-07-17
| ||
| 18:12 | Enhance the sqlite3_analyzer tool to give reports on the sizes of individual indices. file: [f87fc8e4] check-in: [3b4096cc] user: drh branch: trunk, size: 26574 | |
|
2012-10-10
| ||
| 10:52 | Add support for URI filenames in sqlite3_analyzer. file: [76f583a2] check-in: [6dc987d3] user: drh branch: trunk, size: 26090 | |
|
2012-04-06
| ||
| 00:09 | Update sqlite3_analyzer to correctly find all database files when the multiplexor is being used. file: [e4227300] check-in: [1bfc30cb] user: drh branch: trunk, size: 25910 | |
|
2011-10-10
| ||
| 16:06 | Enhance sqlite3_analyzer so that it is able to deal with multiplexed databases that have 8+3 filenames. file: [15f6cd93] check-in: [e5169f9a] user: drh branch: trunk, size: 25946 | |
|
2011-10-05
| ||
| 19:46 | Add the --pageinfo and --stats options to the sqlite3_analyzer utility. file: [2dc915c2] check-in: [baa80c7b] user: drh branch: trunk, size: 25333 | |
| 18:18 | Update the sqlite3_analyzer utility program to provide more details about the compression performance of ZIPVFS database files. file: [7ba8b978] check-in: [fa5ed532] user: drh branch: trunk, size: 23688 | |
|
2011-09-28
| ||
| 00:50 | Enhance the stat VFS to report out the total size of all pages used by a table, even if the ZIPVFS compression backend is in play. Update the sqlite3_analyzer logic to use these new outputs. file: [58d35738] check-in: [19b8eaaf] user: drh branch: trunk, size: 22173 | |
|
2011-09-27
| ||
| 13:40 | Changes to sqlite3_analyzer to try to avoid integer overflow problems when linking against older versions of TCL. file: [7591cccc] check-in: [8c846311] user: drh branch: trunk, size: 21810 | |
|
2011-09-26
| ||
| 19:32 | Changes to the analyzer script to make it work with zipvfs databases. file: [a7ffc29b] check-in: [d82cffab] user: dan branch: trunk, size: 21788 | |
|
2011-09-21
| ||
| 20:10 | Minor tweaks to the TCL code for sqlite3_analyzer. file: [537f35d9] check-in: [3a261f38] user: drh branch: trunk, size: 21481 | |
|
2011-09-15
| ||
| 00:40 | Cleanup/fix error handling when no arguments are supplied to the SQLite analyzer. file: [fe02dede] check-in: [3fc566ac] user: mistachkin branch: trunk, size: 21465 | |
|
2011-08-31
| ||
| 17:46 | Backslash escaping is not working right in tostr.awk on the latest ubuntu. The easiest fix is to simply not use any backslashes in the spaceanal.tcl script. file: [1ee4df4e] check-in: [df550066] user: drh branch: trunk, size: 21348 | |
|
2010-07-12
| ||
| 08:39 | Changes so that the space-analyzer script works with 3.7.0. file: [b91879d5] check-in: [86159cb3] user: dan branch: trunk, size: 21357 | |
|
2007-12-04
| ||
| 13:41 | Fix a bug in the TCL code for sqlite3_analyzer. (CVS 4590) file: [b87db46a] check-in: [7c2cf454] user: drh branch: trunk, size: 30555 | |
|
2007-02-13
| ||
| 01:41 | Explanation of the "fragmentation" line is added to the help message at the end of the output of sqlite3_analyzer. (CVS 3636) file: [f60a242a] check-in: [31e5073c] user: drh branch: trunk, size: 30481 | |
| 01:38 | Additional fixes to the new fragmentation feature of sqlite3_analyzer. (CVS 3635) file: [5c7b0174] check-in: [82aed271] user: drh branch: trunk, size: 30155 | |
|
2007-02-10
| ||
| 19:22 | Changes to support fragmentation analysis in sqlite3_analyzer. (CVS 3634) file: [2614b0c9] check-in: [bd6bc3b8] user: drh branch: trunk, size: 30192 | |
|
2006-10-03
| ||
| 12:08 | Fix sqlite3_analyzer so that it works when compiled against Tcl8.5. (CVS 3458) file: [f4ca4843] check-in: [e774adce] user: drh branch: trunk, size: 28936 | |
| 12:04 | Fix sqlite3_analyzer so that it works on databases containing virtual tables. (CVS 3457) file: [347bb735] check-in: [47c8567f] user: drh branch: trunk, size: 28924 | |
|
2006-02-09
| ||
| 02:41 | Use 64-bit integers in sqlite3_analyzer. Ticket #1666. (CVS 3059) file: [9e134a26] check-in: [8b3068ac] user: drh branch: trunk, size: 28906 | |
|
2006-01-24
| ||
| 02:19 | Sqlite3_analyzer reports an error if it runs into trouble. (CVS 3021) file: [ceaee5ce] check-in: [388b9262] user: drh branch: trunk, size: 28690 | |
|
2005-03-29
| ||
| 13:18 | Fix minor display bugs in sqlite3_analyzer. (CVS 2431) file: [5b47b70b] check-in: [d89aaba5] user: drh branch: trunk, size: 28615 | |
|
2005-02-01
| ||
| 10:36 | Space analyzer: Format integer results as integers. Also fix the calculation of average-fanout. (CVS 2304) file: [184f5e59] check-in: [52e473b9] user: danielk1977 branch: trunk, size: 28610 | |
|
2004-11-09
| ||
| 07:42 | Refactor the space-analysis script for readability. (CVS 2081) file: [102d6dcb] check-in: [63f2ee22] user: danielk1977 branch: trunk, size: 28088 | |
|
2004-11-08
| ||
| 16:15 | Update the space-analyzer tool to support auto-vacuum databases. (CVS 2080) file: [a1ba7f05] check-in: [1cb80866] user: danielk1977 branch: trunk, size: 21186 | |
|
2004-07-23
| ||
| 00:01 | First cut at a analysis tool for version 3.0 databases. (CVS 1862) file: [c8c39c46] check-in: [7c7f698b] user: drh branch: trunk, size: 18347 Added | |
|
2004-06-19
| ||
| 11:57 | Add the source code to the sqlite_analyzer utility. (CVS 1637) file: [fec99070] check-in: [06bf4c7e] user: drh branch: version_2, size: 15334 Added | |