Rules
Terms of Use

Topic Options
#265752 - Sat Apr 30 2005 06:25 PM Expect some ranking changes...
Terry Online   FT-blank
Head Honcho

Registered: Wed Dec 31 1969
Posts: 20631
Loc: USA
FunTrivia has been storing all results of all players since the quiz system was built. The player results database now has over 30 MILLION entries. Needless to say, this is starting to take its toll on performance of the server and space and time used to back that thing up (the index itself is over a gigabyte large).

Sooo... I'm now deleting all quiz scores of all players who have not been seen on FunTrivia for 1.5 years.

Therefore, players who played in 2002 but havent played since will have their records deleted to free up space for new and existing players.

What this means is that ratings that players may have set on quizzes years ago may no longer contribute to your rank. I'm not sure if this will make a huge difference, as older quizzes tend to have been played a lot more times, but it's certainly possible that the deletion of old user ratings may push some quizzes into the unranked category (therefore getting an "average" rank. It also means that the more recent plays of a quiz are more significant to rank.

Terry

Top
#265753 - Sat Apr 30 2005 09:14 PM Re: Expect some ranking changes...
picqero Offline
Multiloquent

Registered: Tue Dec 28 2004
Posts: 2813
Loc: Hertfordshire<br>England UK
Seems a good idea. A 'side-effect' might be to move some poorly written quizzes, having little or no interesting information, further down the ratings.

Top
#265754 - Mon May 02 2005 03:24 PM Re: Expect some ranking changes...
dg_dave Offline
Champion Poster

Registered: Sun Oct 05 2003
Posts: 23675
Loc: near Stafford, Virginia USA  
Quote:

Sooo... I'm now deleting all quiz scores of all players who have not been seen on FunTrivia for 1.5 years.




Question for you Terry, if the scores are getting deleted, then why is the particular user's score still what it was but have now played zero quizzes?
_________________________
The way to get things done is NOT to mind who gets the credit for doing them. --Benjamin Jowett
No one can make you feel inferior without your consent. --Eleanor Roosevelt
The day we lose our will to fight is the day we lose our freedom.

Top
#265755 - Tue May 03 2005 07:10 AM Re: Expect some ranking changes...
Terry Online   FT-blank
Head Honcho

Registered: Wed Dec 31 1969
Posts: 20631
Loc: USA
<< Question for you Terry, if the scores are getting deleted, then why is the particular user's score still what it was but have now played zero quizzes? >>

which "particular" user are you referring to??

Top
#265756 - Tue May 03 2005 07:48 AM Re: Expect some ranking changes...
ren33 Offline
Moderator

Registered: Thu Sep 30 1999
Posts: 12427
Loc: Kowloon Tong  Hong Kong      
In the Hall of Fame for Gold Players, Terry, there are 8 names in the first 100 players alone who have high scores but have played nil quizzes.
_________________________
Wandering aimlessly through FT since 1999.

Top
#265757 - Tue May 03 2005 09:00 PM Re: Expect some ranking changes...
features2004 Offline
Explorer

Registered: Thu Mar 24 2005
Posts: 64
Loc: Asia.
I liked your idea. Will there be changes in both player's rank and quiz's rank?

Top
#265758 - Thu May 05 2005 09:04 AM Re: Expect some ranking changes...
Auszev Offline
Forum Adept

Registered: Tue Dec 10 2002
Posts: 181
Loc: Perth
Western Australia
Just a thought: Many of the categories have been closed off - why not have a "spring clean" here as well. I do not know if any of the really old (which have questions in them that are outmoded) or quizzes that are not written well are every dropped from the system, but it would help free up these categories. Perhaps they could be sent back to the authors (might not be a popular suggestion though).

Top

Moderator:  agony