Comment by nickvec
10 hours ago
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.
Or just redis cache?
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
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.
1 reply →