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 5 hours ago | parent [-]

Or just redis cache?

▲

nickvec 3 hours ago | parent [-]

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

▲

KolmogorovComp 2 hours ago | parent [-]

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.

	▲	Imustaskforhelp 2 hours ago \| parent [-]
		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!