third_party/sqlite/src/doc/report1.txt - Issue 6823057: Cleanup SQLite 3.6.18 import.

Side by Side Diff

Use n/p to move between diff chunks; N/P to move between comments. Draft comments are only viewable by you.

Keyboard Shortcuts

	File
u :	up to issue
j / k :	jump to file after / before current file
J / K :	jump to next file with a comment after / before current file
	Side-by-side diff
i :	toggle intra-line diffs
e :	expand all comments
c :	collapse all comments
s :	toggle showing all comments
n / p :	next / previous diff chunk or comment
N / P :	next / previous comment
<Up> / <Down> :	next / previous line

	Issue
u :	up to list of issues
j / k :	jump to patch after / before current patch
o / <Enter> :	open current patch in side-by-side view
i :	open current patch in unified diff view

	Issue List
j / k :	jump to issue after / before current issue
o / <Enter> :	open current issue

Side by Side Diff: third_party/sqlite/src/doc/report1.txt

Issue 6823057: Cleanup SQLite 3.6.18 import. (Closed) Base URL: svn://svn.chromium.org/chrome/trunk/src

Patch Set: Created 9 years, 8 months ago

Use n/p to move between diff chunks; N/P to move between comments. Draft comments are only viewable by you.

Jump to:

View unified diff | Download patch | Annotate | Revision Log

OLD	NEW
	(Empty)
1 An SQLite (version 1.0) database was used in a large military application

2 where the database contained 105 tables and indices. The following is

3 a breakdown on the sizes of keys and data within these tables and indices:

4

5 Entries: 967089

6 Size: 45896104

7 Avg Size: 48

8 Key Size: 11112265

9 Avg Key Size: 12

10 Max Key Size: 99

11

12 0..8 263 0%

13 9..12 5560 0%

14 13..16 71394 7%

15 17..24 180717 26%

16 25..32 215442 48%

17 33..40 151118 64%

18 41..48 77479 72%

19 49..56 13983 74%

20 57..64 14481 75%

21 65..80 41342 79%

22 81..96 127098 92%

23 97..112 38054 96%

24 113..128 14197 98%

25 129..144 8208 99%

26 145..160 3326 99%

27 161..176 1242 99%

28 177..192 604 99%

29 193..208 222 99%

30 209..224 213 99%

31 225..240 132 99%

32 241..256 58 99%

33 257..288 515 99%

34 289..320 64 99%

35 321..352 39 99%

36 353..384 44 99%

37 385..416 25 99%

38 417..448 24 99%

39 449..480 26 99%

40 481..512 27 99%

41 513..1024 470 99%

42 1025..2048 396 99%

43 2049..4096 187 99%

44 4097..8192 78 99%

45 8193..16384 35 99%

46 16385..32768 17 99%

47 32769..65536 6 99%

48 65537..65541 3 100%

49

50 If the indices are omitted, the statistics for the 49 tables

51 become the following:

52

53 Entries: 451103

54 Size: 30930282

55 Avg Size: 69

56 Key Size: 1804412

57 Avg Key Size: 4

58 Max Key Size: 4

59

60 0..24 89 0%

61 25..32 9417 2%

62 33..40 119162 28%

63 41..48 68710 43%

64 49..56 9539 45%

65 57..64 12435 48%

66 65..80 38650 57%

67 81..96 126877 85%

68 97..112 38030 93%

69 113..128 14183 96%

70 129..144 7668 98%

71 145..160 3302 99%

72 161..176 1238 99%

73 177..192 597 99%

74 193..208 217 99%

75 209..224 211 99%

76 225..240 130 99%

77 241..256 57 99%

78 257..288 100 99%

79 289..320 62 99%

80 321..352 34 99%

81 353..384 43 99%

82 385..416 24 99%

83 417..448 24 99%

84 449..480 25 99%

85 481..512 27 99%

86 513..1024 153 99%

87 1025..2048 92 99%

88 2049..4096 7 100%

89

90 The 56 indices have these statistics:

91

92 Entries: 512422

93 Size: 14879828

94 Avg Size: 30

95 Key Size: 9253204

96 Avg Key Size: 19

97 Max Key Size: 99

98

99 0..8 246 0%

100 9..12 5486 1%

101 13..16 70717 14%

102 17..24 178246 49%

103 25..32 205722 89%

104 33..40 31951 96%

105 41..48 8768 97%

106 49..56 4444 98%

107 57..64 2046 99%

108 65..80 2691 99%

109 81..96 202 99%

110 97..112 11 99%

111 113..144 527 99%

112 145..160 20 99%

113 161..288 406 99%

114 289..1024 316 99%

115 1025..2048 304 99%

116 2049..4096 180 99%

117 4097..8192 78 99%

118 8193..16384 35 99%

119 16385..32768 17 99%

120 32769..65536 6 99%

121 65537..65541 3 100%

OLD	NEW

« no previous file with comments | « third_party/sqlite/src/doc/lemon.html ('k') | third_party/sqlite/src/ext/fts1/fts1.c » ('j') | no next file with comments »