Skip to content

stats 260627

Jump to bottom
Pavel Zbytovský edited this page Jun 27, 2026 · 1 revision

OpenClimbing — Tile Cache Statistics (last 30 days)

Period: 2026-05-27 – 2026-06-27
Total builds analysed: 1,385
Source: climbing_tiles_stats table from the OpenClimbing SQLite export

Slowest tile per build (max_time_zxy)

Which tile was the slowest to render in each build.

Tile (z/x/y) Occurrences % of builds Avg ms Max ms Min ms
6/34/21 267 19.3% 169.9 599 120
0/0/0 198 14.3% -1.0 -1 -1
6/33/22 50 3.6% 181.9 359 95
12/2210/1395 31 2.2% 18.6 65 10
12/2208/1390 31 2.2% 17.3 37 13
12/2207/1374 30 2.2% 17.1 46 12
6/34/22 26 1.9% 218.7 663 89
6/35/21 24 1.7% 234.6 444 84
6/33/21 19 1.4% 172.5 333 79
6/32/22 11 0.8% 124.0 222 82
12/2220/1373 11 0.8% 23.4 37 16
6/33/23 10 0.7% 249.6 381 104
6/10/24 10 0.7% 164.1 432 76
12/2228/1373 10 0.7% 15.2 38 9
12/2221/1390 10 0.7% 11.8 28 9
12/2210/1394 9 0.6% 13.4 21 9
12/2210/1387 9 0.6% 17.7 81 8
6/35/22 8 0.6% 206.4 420 83
12/2219/1373 8 0.6% 34.0 132 6
6/32/21 7 0.5% 186.3 330 73

Note: 0/0/0 entries with -1 ms likely indicate a cache hit or skipped render, not a real measurement.

Largest tile per build (max_size_zxy)

Tile (z/x/y) Occurrences % of builds Avg size (KB) Max size (KB)
0/0/0 1,385 100.0% 1768.8 1797.7

Tile 0/0/0 (whole world, zoom 0) is always the largest — it grew from ~537 KB to ~1,798 KB over the month as new data was added.

Render time distribution (max_time)

Range Builds Share
1–49 ms 777 ████████████████ 56.1%
50–99 ms 108 ██ 7.8%
100–199 ms 339 ███████ 24.5%
200–499 ms 156 ███ 11.3%
500+ ms 5 █ 0.4%

Cache was always active — zero builds had max_time = 0 or NULL during this period.

Daily summary

Date Builds Avg build (s) Routes Groups Avg max tile (KB) Avg max tile (ms)
2026-05-27 75 4.7 29,822 28,840 1757.0 64.2
2026-05-28 85 4.5 29,915 28,866 1757.1 53.0
2026-05-29 90 4.5 30,082 28,899 1757.2 43.1
2026-05-30 73 4.5 30,699 28,950 1758.3 45.0
2026-05-31 95 4.6 33,777 29,446 1759.2 59.0
2026-06-01 40 4.7 33,940 29,460 1760.2 91.2
2026-06-02 57 4.7 33,966 29,475 1760.8 76.8
2026-06-03 18 4.7 33,974 29,478 1760.8 144.6
2026-06-04 35 4.8 33,978 29,481 1761.2 86.6
2026-06-05 49 4.7 34,347 29,497 1761.8 98.2
2026-06-06 31 4.8 34,347 29,505 1762.2 106.6
2026-06-07 20 5.1 34,366 29,505 1762.3 128.9
2026-06-08 55 4.8 34,382 29,518 1762.8 78.0
2026-06-09 36 5.0 34,418 29,560 1763.7 138.7
2026-06-10 27 5.0 34,567 29,573 1764.3 102.1
2026-06-11 28 5.9 34,876 29,596 1765.3 113.4
2026-06-12 26 5.8 34,853 29,596 1765.8 139.2
2026-06-13 33 5.9 34,853 29,605 1766.0 80.8
2026-06-14 98 5.4 34,866 29,607 1766.6 47.2
2026-06-15 63 5.6 34,876 29,621 1767.8 60.6
2026-06-16 24 5.4 34,881 29,630 1768.7 139.0
2026-06-17 34 5.4 35,008 29,645 1769.7 66.4
2026-06-18 27 6.0 35,015 29,683 1775.1 95.5
2026-06-19 22 7.8 35,121 29,692 1796.2 107.3
2026-06-20 48 7.0 35,135 29,702 1796.7 70.9
2026-06-21 40 7.6 35,138 29,703 1796.7 84.1
2026-06-22 33 7.2 35,151 29,720 1796.8 84.7
2026-06-23 37 7.1 35,169 29,742 1797.0 95.0
2026-06-24 24 7.3 35,169 29,745 1797.3 100.7
2026-06-25 27 10.6 35,171 29,759 1797.5 146.5
2026-06-26 34 11.3 35,176 29,768 1797.4 147.5
2026-06-27 1 12.0 35,176 29,768 1797.7 227.0

Key findings

  • 6/34/21 (Alps / Central Europe, zoom 6) is the consistent performance hotspot — it was the slowest tile in 19.3 % of all builds, with a peak of 599 ms.
  • Build duration doubled over the month: from ~4.7 s in late May to ~12 s by late June, driven by data growth (+5,580 routes, +1,062 groups).
  • The world overview tile 0/0/0 more than tripled in size: 537 KB → 1,798 KB.
  • 56 % of builds finished their slowest tile render in under 50 ms.
  • Only 5 builds in the entire month exceeded 500 ms on a single tile render.

Clone this wiki locally