zlacker

>>Imusta+(OP)
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.

>>nickve+VV9
Or just redis cache?

>>system+WW9
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

>>nickve+S7a
It’s a static page, there is no backend. That’s why a static list, for example computed every day via an action is the way to go.