Jump to content
Sign in to follow this  
CA3LE

Score Database

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).

Share this post


Link to post
Share on other sites

:) Yeah I agree non members scores  shouldn't be kept for very Long maybe a few months, maybe it Will encourage non-members to join.............and man thanks for keeping all this data for all of us.... :) its all about the smartest........

8) Microwave

Share this post


Link to post
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

Share this post


Link to post
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.

Share this post


Link to post
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..

Share this post


Link to post
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
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.

Sign in to follow this  

×
×
  • Create New...