It may be possible to speed up the database by using fixed-width fields for titles. Tim Starling was wondering what length we should use. Here are some results of that wondering.

See also: longest titles on nl, Awards for the longest title.

Effects of large blobs on InnoDB speed

Graphs

edit

 

 


  • Total article count (en+de+ja+zh only) 544899 (may include redirects)
  • Average title length is 16.3
  • 50% are 14 or shorter; 272,000 longer; de+za: 26%; 36,338
  • 77% are 21 or shorter; 122,982 longer; de+za: 85%; 14,541
  • 90% are 28 or shorter; 52,134 longer; de+za: 94%; 5,558
  • 95% are 34 or shorter; 26,672 longer; de+za: 97%; 2,527
  • 99% are 48 or shorter; 5,301 longer; de+za: 99.6%; 432
  • 99.5% are 52 or shorter; 2,947 longer
  • 99.76% are 59 or shorter; 1,309 longer; de+za: 99.88%; 116
  • 99.9% are 69 or shorter; 475 longer
  • 99.95% are 75 or shorter; 268 longer
  • 99.99% are 95 or shorter; 93 longer
  • 99.996% are 110 or shorter; 19 longer
  • 99.999% are 173 or shorter; 3 longer

Source data and summary, no graphs (Excel 95 XLS format).

Data

edit
l       en      de      ja      zh
0       0       0       1       1
1       207     58      45      33
2       1351    605     206     14
3       5268    2584    974     163
4       7798    3372    401     95
5       9534    3527    303     106
6       13056   4274    4854    1305
7       15079   4454    1495    238
8       16023   4622    551     208
9       16053   5097    7268    1503
10      17245   5368    541     251
11      19217   6098    442     228
12      21078   6980    7579    1222
13      22129   4740    380     208
14      21527   4457    302     175
15      20082   3891    5110    633
16      19078   3377    363     98
17      17730   3089    206     123
18      17215   2855    3433    474
19      14937   2556    296     96
20      13602   2226    202     142
21      12246   1944    2725    293
22      11226   1781    146     84
23      9933    1671    157     75
24      8940    1289    1934    167
25      8353    1201    154     58
26      7590    917     117     46
27      6204    894     1539    98
28      5453    657     119     45
29      4726    638     67      19
30      3976    552     1271    72
31      3601    498     80      25
32      3033    394     50      31
33      2524    395     872     37
34      2174    299     57      71
35      1890    326     47      6
36      1768    215     546     26
37      1531    222     44      5
38      1382    173     23      1
39      1268    163     384     13
40      1187    128     47      3
41      1104    162     17      1
42      1065    116     295     14
43      1130    99      44      1
44      1083    75      5       1
45      1194    76      167     9
46      1083    81      16      0
47      960     66      11      0
48      862     103     123     10
49      666     49      17      1
50      602     45      10      7
51      437     43      89      1
52      348     25      12      2
53      294     28      5       0
54      281     22      58      1
55      201     25      4       2
56      161     22      5       0
57      177     16      37      0
58      156     19      4       0
59      107     8       5       0
60      92      6       33      3
61      82      9       2       0
62      81      16      2       0
63      68      8       17      0
64      105     8       2       1
65      46      6       1       0
66      44      4       13      0
67      50      7       1       0
68      47      9       1       0
69      48      7       15      0
70      30      2       0       0
71      41      0       3       0
72      34      4       6       0
73      21      1       1       0
74      23      4       6       0
75      23      2       6       0
76      18      2       2       0
77      22      1       1       0
78      21      1       5       0
79      22      2       0       0
80      11      1       2       0
81      7       0       0       0
82      4       0       0       0
83      9       0       0       0
84      9       0       1       0
85      8       0       1       0
86      4       0       0       0
87      6       2       0       0
88      2       3       0       0
89      3       1       0       0
90      4       0       0       0
91      3       0       1       0
92      3       0       1       0
93      2       0       1       0
94      1       0       0       0
95      3       0       1       0
96      3       0       2       0
97      3       1       0       0
98      5       0       0       0
99      6       0       3       0
100     1       0       1       0
101     1       0       0       0
102     0       0       2       0
103     2       0       0       0
104     5       2       0       0
105     2       0       1       0
106     2       2       0       0
107     3       0       0       0
108     1       0       1       0
109     1       1       0       0
110     7       0       0       0
111     1       0       0       0
112     2       0       0       0
113     0       0       0       0
114     1       0       0       0
115     0       0       0       0
116     0       0       0       0
117     0       0       0       0
118     0       0       0       0
119     0       0       0       0
120     0       0       0       0
121     0       0       0       0
122     1       0       0       0
123     0       0       0       0
124     1       0       0       0
125     0       0       0       0
126     1       0       0       0
127     0       0       0       0
128     0       0       0       0
129     0       0       0       0
130     0       0       0       0
131     0       0       0       0
132     0       0       0       0
133     0       0       0       0
134     0       0       0       0
135     0       0       0       0
136     0       0       0       0
137     0       0       0       0
138     0       0       1       0
139     0       0       0       0
140     0       0       0       0
141     0       0       0       0
142     0       0       0       0
143     0       0       0       0
144     2       0       0       0
145     0       0       0       0
146     0       0       0       0
147     0       0       0       0
148     0       0       0       0
149     0       0       0       0
150     0       0       0       0
151     1       0       0       0
152     0       0       0       0
153     0       0       0       0
154     0       0       0       0
155     1       0       0       0
156     0       0       0       0
157     0       0       0       0
158     0       0       0       0
159     0       0       0       0
160     0       0       0       0
161     0       0       0       0
162     0       0       0       0
163     1       0       0       0
164     1       0       0       0
165     0       0       0       0
166     0       0       0       0
167     0       0       0       0
168     0       0       0       0
169     0       0       0       0
170     0       0       0       0
171     0       0       0       0
172     0       0       0       0
173     2       0       0       0
174     0       0       0       0
175     0       0       0       0
176     0       0       0       0
177     0       0       2       0
178     0       0       0       0
179     0       0       0       0
180     0       0       0       0
181     0       0       0       0
182     0       0       0       0
183     0       0       0       0
184     0       0       0       0
185     0       0       0       0
186     0       0       0       0
187     0       0       0       0
188     1       0       0       0
189     0       0       0       0
190     0       0       0       0
191     0       0       0       0
192     0       0       0       0
193     0       0       0       0
194     0       0       0       0
195     0       0       0       0
196     0       0       0       0
197     0       0       0       0
198     0       0       0       0
199     0       0       0       0
200     0       0       0       0
201     0       0       0       0
202     0       0       0       0
203     0       0       0       0
204     0       0       0       0
205     0       0       0       0
206     0       0       0       0
207     0       0       0       0
208     0       0       0       0
209     0       0       0       0
210     0       0       0       0
211     0       0       0       0
212     0       0       0       0
213     0       0       0       0
214     0       0       0       0
215     0       0       0       0
216     0       0       0       0
217     0       0       0       0
218     0       0       0       0
219     0       0       0       0
220     0       0       0       0
221     0       0       0       0
222     0       0       0       0
223     0       0       0       0
224     0       0       0       0
225     0       0       0       0
226     0       0       0       0
227     0       0       0       0
228     0       0       0       0
229     0       0       0       0
230     0       0       0       0
231     0       0       0       0
232     0       0       0       0
233     0       0       0       0
234     0       0       0       0
235     0       0       0       0
236     0       0       0       0
237     0       0       0       0
238     0       0       0       0
239     0       0       0       0
240     0       0       0       0
241     0       0       0       0
242     0       0       0       0
243     0       0       0       0
244     0       0       0       0
245     0       0       0       0
246     0       0       0       0
247     0       0       0       0
248     0       0       0       0
249     0       0       0       0
250     0       0       0       0
251     0       0       0       0
252     0       0       0       0
253     0       0       0       0
254     0       0       0       0
255     2       0       0       0