Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

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.


Author here! Thanks this is the thought I was having too.

Got Quite a lot of feedback which is what I am greatful for having. Firstly gonna fix the name-casing issue & then this is my second priority!


Update: Done! [Most likely, If I find the time to do so,I will keep an eye on it for a few days to see if its computed daily or not but I am most likely sure that it might be the case]




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: