⚠ Switch to EXCALIDRAW VIEW in the MORE OPTIONS menu of this document. ⚠
Text Elements
user/game
post new score
Application server
handle fetches for leaderboard scores
Relational DB
specific user queries
there will be a disproportionate amount of requests made for the top 100 of the leaderboard.
Key
Key
Value
Value
Cache
request for top ~100
bust cache when score beats worst score in cached query
btree index on score in score table.
look up for scores near a user’s score should be logarithmic because values will be grouped in the btree index.