Jump to content

Score Database


CA3LE

How long do you think TestMy.net should keep records of scores?  

19 members have voted

  1. 1. How long do you think TestMy.net should keep records of scores?

    • 1 Month
      6
    • 2-3 Months
      4
    • 6 Months
      3
    • 1 Year
      4
    • Forever
      2


Recommended Posts

User input needed, my database is aproching 2 million records and I need to start thinking about what I am going to do...

If I do trash scores it will only be for non-members - once signed up your scores would stay in the DB forever (or almost forever).

Link to comment
Share on other sites

I think that a month is more than enough, why have that space taken up for really no reason.??. However I agree with 'resopalrabotnick ' I think this is the best answer yet. Plus with it only saving 3days of Non Members it might make them want to join. However I don't see why they don't go ahead and join anyway, cause this is the most accurate site as far as speed tests goes. At least I think so anyway. It is by far the best that I have come accross, plus you can't beat the people here either.  :D :D

Link to comment
Share on other sites

You seem bent on getting more members here, yet most still don't post. Also, it seems that many are only interested in getting their speed up to par and then they leave. And if their speed is fine already, they don't bother to post.

I vote for a fixed size of the database, and a 1 year save for members.

Link to comment
Share on other sites

I have to also factor in the cut and paste deal, test validation... once removed from the database the score will no longer be able to be pulled up.  But I guess upon lookup if a score is not in the DB I could give a message like "No results found, this does not necessarily mean the score you are trying to validate is fake, TestMy.net only keeps non-member stats for X months" -- The reason this is a factor is because alot of people post those validation links in other forums (that was the whole reason I made that... to market the site ;-)) and if those links die too quickly it would be a bad thing.

But I think, myself, that two months should be good... and 1 year for members, doing this now (back to Dec 1st) would prune 1.2 million records and leave me with 420,000 records..... which is still a buttload to work with.  Dealing with a database this big sucks because to execute a command that effects the whole database takes a VERY long time to do.

Keep voting..

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...