Avg Rank Ranking (suggestions on no huge server load inside)

[dore]

So, we all want an average rank ranking, but we all know that it would cause (number of players)*(number of songs) server queries every time it is calculated.

Last night, I was thinking about this, and I thought of a way to get around that: Every time someone accesses their level rank page, their average rank would be updated using that calculation. This way, there would be no extra server queries, and the ranking would be pretty much real time, as all the people who care check it frequently anyway. In other words, every time someone accesses their level rank it updates their place on the list.

The downside is that it would have to be calculated the first time with the massive amount of server queries, but after that, it would cause no extra load.

It's kind of late at night so I know my word choice is not the best, so feel free to ask me to clarify what I mean.

I think this would work well.

[jimerax]

Re: Avg Rank Ranking (suggestions on no huge server load inside)

someone opens level rank list -> calculate average rank -> record the average rank to TOP list database -> TOP list is shown when someone opens it

It seems any process won't burden impossibly huge tasks to the server.
Hopefully the calculated date is also shown when we see the TOP list.

[Tasselfoot]

Re: Avg Rank Ranking (suggestions on no huge server load inside)

dore: the only way to calculate someones place on the list is to run the entire query. otherwise there is no way to know if someone else passed you or not.


as synth and i have said in other threads... the way to do it would be like ffr siggy's overall rank. we'd have to do it manually. run the query once a day or something. which is probably doable, if it is done late at night or during the weekday on a M-F.

[lightdarkness]

Re: Avg Rank Ranking (suggestions on no huge server load inside)

Your average rank is already stored when you view that page, I can give a rough list, but it's highly inaccurate.

[dore]

Re: Avg Rank Ranking (suggestions on no huge server load inside)

Your average rank is already stored when you view that page, I can give a rough list, but it's highly inaccurate.

Yeah, that's the list I want, it'd be very rough but still useful.

[Doug31]

Re: Avg Rank Ranking (suggestions on no huge server load inside)

Probably be more accurate than Tass' list, (updated 9/30.)

[Vote4Nixon]

Re: Avg Rank Ranking (suggestions on no huge server load inside)

I like Tass's/Synth's idea to manually run the query of order (number of songs) * (number of players) each day, say around 3-4 am so it doesn't affect gameplay too much. Granted, it wouldn't be a real-time average rank list, but it would be a lot less rough than dore's idea, which I'm not saying is bad at all. Also, the average rank update wouldn't depend on "how much a person cares about their rank," even though the top 100 average ranks probably belong to players who view their levelrank.php page frequently. All players in the FFR community, obsessed or not, would be taken into account.

Furthermore, I don't think most people would mind if there were a few cutbacks on some features to implement an average rank system. Honestly, it would be nicer to be able to see the Top 100 overall scores and Top 100 average scores, rather than the Top 1000 overall scores.

EDIT: Just thought of this question after reading Ryusei's suggestion on including average ranks in people's profile: When are average ranks calculated? Is the average rank updated whenever a player plays a song? Is it updated when someone decides to view his/her levelrank.php page?

[dore]

Re: Avg Rank Ranking (suggestions on no huge server load inside)

Average rank is calculated whenever you view your levelrank.

[Megmo]

Re: Avg Rank Ranking (suggestions on no huge server load inside)

Yeah, your average ranking shows up at the bottom of your levelranking stats for all the songs, but I think they're trying to say that they want their average ranking to be compared to everyone elses. I like the idea.

[windsurfer-sp]

Re: Avg Rank Ranking (suggestions on no huge server load inside)

My idea would to run a query such as:
If overall rank is <500 then calculate avg. level rank then place in "Top 100 Avg. Rank List".
Sort "Top 100 Avg. Rank List".

Obivously this the completly wrong coding words/descrpition/process.

The idea behind is that it only works out the avg. level rank of 500 players. The 500 ranks are placed in a list and then are sorted so lowest rank is on top. The top 100 people are placed on the top 100 avg. rank list.

This way the no. of queries is 500*number of songs instead of ~1,000,000*number of songs. (Not including the process of worknng out who is in the top 500 which would take the number of players worth of queries. That could be solved by running the query inside of the top 1000 list if possible.)

This query could be run daily at a low usage time. IDK if this is possible or makes sense but its my idea on the topic.

[Tasselfoot]

Re: Avg Rank Ranking (suggestions on no huge server load inside)

doesn't work that way. can't figure out who is under 500 without running the full query.