[nickvec]

Cool! Just a thought: instead of having to query the Clickhouse cluster whenever a client clicks "View Top 1000 Leaderboard" (which could cause a lot of load), it might be useful to instead fetch the top 1000 every hour (day?) and display the top 1000 as a static list.

[system2]

Or just redis cache?

[nickvec]

Oops, yeah, that's what I initially was trying to get across but ended up replacing cache with static list for reasons I am unsure of