Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Use 64-bit integers in sqlite3_analyzer. Ticket #1666. (CVS 3059) |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: | 8b3068aca7b28d2b6c326f632bb9fe9b |
| User & Date: | drh 2006-02-09 02:41:08 |
Context
|
2006-02-09
| ||
| 02:56 | Correctly handle COLLATE clauses in tables being modified by an ALTER TABLE ADD COLUMN command. Ticket #1665. (CVS 3060) check-in: baef2f66 user: drh tags: trunk | |
| 02:41 | Use 64-bit integers in sqlite3_analyzer. Ticket #1666. (CVS 3059) check-in: 8b3068ac user: drh tags: trunk | |
|
2006-02-06
| ||
| 21:34 | Add "autoinc" and "collseq" columns to the table_info() pragma. (CVS 3058) check-in: 7940a590 user: drh tags: trunk | |
Changes
Changes to tool/spaceanal.tcl.
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
...
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
|
#
set sql {
SELECT name, rootpage FROM sqlite_master WHERE type='table'
UNION ALL
SELECT 'sqlite_master', 1
ORDER BY 1
}
foreach {name rootpage} [db eval $sql] {
puts stderr "Analyzing table $name..."
# Code below traverses the table being analyzed (table name $name), using the
# btree cursor $cursor. Statistics related to table $name are accumulated in
# the following variables:
#
set total_payload 0 ;# Payload space used by all entries
set total_ovfl 0 ;# Payload space on overflow pages
set unused_int 0 ;# Unused space on interior nodes
set unused_leaf 0 ;# Unused space on leaf nodes
set unused_ovfl 0 ;# Unused space on overflow pages
set cnt_ovfl 0 ;# Number of entries that use overflows
set cnt_leaf_entry 0 ;# Number of leaf entries
set cnt_int_entry 0 ;# Number of interor entries
set mx_payload 0 ;# Maximum payload size
set ovfl_pages 0 ;# Number of overflow pages used
set leaf_pages 0 ;# Number of leaf pages
set int_pages 0 ;# Number of interior pages
# As the btree is traversed, the array variable $seen($pgno) is set to 1
# the first time page $pgno is encountered.
#
catch {unset seen}
# The following loop runs once for each entry in table $name. The table
................................................................................
foreach {name tbl_name rootpage} [db eval $sql] {
puts stderr "Analyzing index $name of table $tbl_name..."
# Code below traverses the index being analyzed (index name $name), using the
# btree cursor $cursor. Statistics related to index $name are accumulated in
# the following variables:
#
set total_payload 0 ;# Payload space used by all entries
set total_ovfl 0 ;# Payload space on overflow pages
set unused_leaf 0 ;# Unused space on leaf nodes
set unused_ovfl 0 ;# Unused space on overflow pages
set cnt_ovfl 0 ;# Number of entries that use overflows
set cnt_leaf_entry 0 ;# Number of leaf entries
set mx_payload 0 ;# Maximum payload size
set ovfl_pages 0 ;# Number of overflow pages used
set leaf_pages 0 ;# Number of leaf pages
# As the btree is traversed, the array variable $seen($pgno) is set to 1
# the first time page $pgno is encountered.
#
catch {unset seen}
# The following loop runs once for each entry in index $name. The index
|
>
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
...
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
|
#
set sql {
SELECT name, rootpage FROM sqlite_master WHERE type='table'
UNION ALL
SELECT 'sqlite_master', 1
ORDER BY 1
}
set wideZero [expr {10000000000 - 10000000000}]
foreach {name rootpage} [db eval $sql] {
puts stderr "Analyzing table $name..."
# Code below traverses the table being analyzed (table name $name), using the
# btree cursor $cursor. Statistics related to table $name are accumulated in
# the following variables:
#
set total_payload $wideZero ;# Payload space used by all entries
set total_ovfl $wideZero ;# Payload space on overflow pages
set unused_int $wideZero ;# Unused space on interior nodes
set unused_leaf $wideZero ;# Unused space on leaf nodes
set unused_ovfl $wideZero ;# Unused space on overflow pages
set cnt_ovfl $wideZero ;# Number of entries that use overflows
set cnt_leaf_entry $wideZero ;# Number of leaf entries
set cnt_int_entry $wideZero ;# Number of interor entries
set mx_payload $wideZero ;# Maximum payload size
set ovfl_pages $wideZero ;# Number of overflow pages used
set leaf_pages $wideZero ;# Number of leaf pages
set int_pages $wideZero ;# Number of interior pages
# As the btree is traversed, the array variable $seen($pgno) is set to 1
# the first time page $pgno is encountered.
#
catch {unset seen}
# The following loop runs once for each entry in table $name. The table
................................................................................
foreach {name tbl_name rootpage} [db eval $sql] {
puts stderr "Analyzing index $name of table $tbl_name..."
# Code below traverses the index being analyzed (index name $name), using the
# btree cursor $cursor. Statistics related to index $name are accumulated in
# the following variables:
#
set total_payload $wideZero ;# Payload space used by all entries
set total_ovfl $wideZero ;# Payload space on overflow pages
set unused_leaf $wideZero ;# Unused space on leaf nodes
set unused_ovfl $wideZero ;# Unused space on overflow pages
set cnt_ovfl $wideZero ;# Number of entries that use overflows
set cnt_leaf_entry $wideZero ;# Number of leaf entries
set mx_payload $wideZero ;# Maximum payload size
set ovfl_pages $wideZero ;# Number of overflow pages used
set leaf_pages $wideZero ;# Number of leaf pages
# As the btree is traversed, the array variable $seen($pgno) is set to 1
# the first time page $pgno is encountered.
#
catch {unset seen}
# The following loop runs once for each entry in index $name. The index
|