zlacker

[return to "See how many words you have written in Hacker News comments"]
1. nickve+VV9[view] [source] 2026-02-03 06:17:40
>>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.
◧◩
2. system+WW9[view] [source] 2026-02-03 06:28:13
>>nickve+VV9
Or just redis cache?
◧◩◪
3. nickve+S7a[view] [source] 2026-02-03 08:01:57
>>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
[go to top]