Hi Kasper,
Given the 2 most common queries you mention (top 5 and 5 nearest), I will
assume that these are relative to the current user, so basically, they
would correspond to the top 5 among my friends, and the 5 closest to my own
top score. If that is your intention, I would suggest that you cou
Hi Steve,
I've considered this approach before and I'm partial to going this way
again.
The reason I haven't yet is the fact that I'm fairly confident that the
user patterns would have a lot more highscore list reads than setting of
highscores or adding friends. And most of the reads from highsco
Hi Kasper,
I am assuming that your friend list is symmetric (i.e. If I am your friend
then you are also my friend), which your comments seem to indicate.
First, I would suggest that you drop the friends score as a part of the
clustering key, which eliminates the need to read-before-write.
With t
