Check out ranklist: http://code.google.com/p/google-app-engine-ranklist/
It was developed for Google Code Jam by Google employees: http://googleappengine.blogspot.com/2009/01/google-code-jams-ranking-library.html Nick On 21 July 2010 01:52, Alvin <[email protected]> wrote: > Hi, > > After searching the internet for several weeks, I cannot find an > efficient way to rank entities in a table. > For example, if I store millions of scores of game plays in a table, > and each score has an unique ID, how do I get the rank of a specific > score? In other words, how do I find the rank of certain score by its > unique ID? > > Because each query only returns maximum 1000 entities, it would be a > problem if the target score's rank is larger than 1000. > If we add another column called rank, to track the rank of each > entity, then it costs a lot of computation time to update rank if we > insert a new score. > > Thanks for your help in advance. > > Alvin > > -- > You received this message because you are subscribed to the Google Groups > "Google App Engine" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]<google-appengine%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/google-appengine?hl=en. > > -- You received this message because you are subscribed to the Google Groups "Google App Engine" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en.
