logoalt Hacker News

nickvectoday at 6:17 AM1 replyview on HN

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.


Replies

system2today at 6:28 AM

Or just redis cache?

show 1 reply