Title length
 | This page is kept for historical interest. Any policies mentioned may be obsolete. If you want to revive the topic, you can use the talk page or start a discussion on the community forum. |
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