zlacker

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+(OP)
Or just redis cache?

>>system+11
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+Xb
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.

>>Kolmog+Ph
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!

>>Kolmog+Ph
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]