4 ms·
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),
by nickvec 8mo 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.
- system2 8mo agoOr just redis cache?
- nickvec 8mo agoOops, 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
- KolmogorovComp 8mo agoIt’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.
- Imustaskforhelp 8mo agoAuthor 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!
- Imustaskforhelp 8mo agoUpdate: 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]