CA3LE Posted January 15, 2005 CID Share Posted January 15, 2005 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). Quote Link to comment Share on other sites More sharing options...
Basik Posted January 15, 2005 CID Share Posted January 15, 2005 6 months is long enough.. Thanks for hanging on to those things by the way.. Quote Link to comment Share on other sites More sharing options...
resopalrabotnick Posted January 15, 2005 CID Share Posted January 15, 2005 hm. kill non member scores after one month, give them incentive to sign up if they want to keep em longer. maybe keep member scores 6 months, any scores older than that get trimmed to the best score of the day or week? Quote Link to comment Share on other sites More sharing options...
The Reverend Posted January 15, 2005 CID Share Posted January 15, 2005 30 days is more than adequate isn't it? They aren't referenced all that often so why waste the GiGs? The Reverend Quote Link to comment Share on other sites More sharing options...
organ_shifter Posted January 15, 2005 CID Share Posted January 15, 2005 I also voted for 1 month. Non-members should only get certain benefits after joining. Quote Link to comment Share on other sites More sharing options...
Cobra Posted January 15, 2005 CID Share Posted January 15, 2005 i vote for 2-3 months. then u have some evidence when u complain to ur ISP that ur speed has dropped since a couple months back Quote Link to comment Share on other sites More sharing options...
MICROWAVE Posted January 15, 2005 CID Share Posted January 15, 2005 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........ Microwave Quote Link to comment Share on other sites More sharing options...
The Reverend Posted January 15, 2005 CID Share Posted January 15, 2005 Yes, yet once you factor in the growth rate of this site, long-term storage of old scores is secondary to the theme of the website, and with the constant influx of new members it soon reaches the degree of being wasted space and thus detrimental. Quote Link to comment Share on other sites More sharing options...
resopalrabotnick Posted January 15, 2005 CID Share Posted January 15, 2005 hm, pick a size fo the score database. guests don't get to log for more than 3 days, all other scores are saved until the chosen database size is reached, at which point the oldest saved score gets killed. Quote Link to comment Share on other sites More sharing options...
The Reverend Posted January 15, 2005 CID Share Posted January 15, 2005 Now there you go, that's one that I could live with and that would work for all concerned. Best idea yet! Very nice resopalrabotnick! Quote Link to comment Share on other sites More sharing options...
NoShow Posted January 15, 2005 CID Share Posted January 15, 2005 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 Quote Link to comment Share on other sites More sharing options...
The Reverend Posted January 15, 2005 CID Share Posted January 15, 2005 That's two in favor of 'resopalrabotnicks' brainstorm.... any 'counters' yet? I'm all for the most efficient use of the hardware, and out the door with the useless data. And, it could be easily automated thus not increase your workload. Quote Link to comment Share on other sites More sharing options...
RTB Posted January 15, 2005 CID Share Posted January 15, 2005 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. Quote Link to comment Share on other sites More sharing options...
VanBuren Posted January 15, 2005 CID Share Posted January 15, 2005 2-3 months is enough if i get trouble with my connection, i dont wait more then 1 month to get it resolved, then you have 2 months left of old scores to compare with VanBuren Quote Link to comment Share on other sites More sharing options...
cholla Posted January 15, 2005 CID Share Posted January 15, 2005 heh CA3LE: do what ever you need to to keep testmy,net working at its best. Get rid of whats seldom used& keep what is used the most .For now I am going to vote for 1 month . Cholla Quote Link to comment Share on other sites More sharing options...
just- Posted January 15, 2005 CID Share Posted January 15, 2005 people updating their internet and stuff i think 2 - 3 months is enought Quote Link to comment Share on other sites More sharing options...
CA3LE Posted January 15, 2005 Author CID Share Posted January 15, 2005 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.. Quote Link to comment Share on other sites More sharing options...
The Reverend Posted January 15, 2005 CID Share Posted January 15, 2005 I've hashed it over and over and over. Quote Link to comment Share on other sites More sharing options...
xs1 Posted January 15, 2005 CID Share Posted January 15, 2005 ok well of the current score results.... youll have to -1 from "forever " and +1 to "2 months" .... i wont explain why.... Quote Link to comment Share on other sites More sharing options...
CA3LE Posted January 16, 2005 Author CID Share Posted January 16, 2005 ok well of the current score results.... youll have to -1 from "forever " and +1 to "2 months" .... i wont explain why.... gotcha (does anyone remember that game.. gotcha! That game RULED) Quote Link to comment Share on other sites More sharing options...
CA3LE Posted January 20, 2005 Author CID Share Posted January 20, 2005 Okay.. that tast was HUGE! Deleted rows: 1223186 (Query took 1828.2605 sec) 1.2 million records GONE! Only took 30 minutes for my Dual XEON server to delete them all, some of you might have seen the server lag... done now though Quote Link to comment Share on other sites More sharing options...
MICROWAVE Posted January 20, 2005 CID Share Posted January 20, 2005 Cool Pfffft just like that gone.... and yes I did notice a small lag while you were working .... I had an idea you were doing that because you stayed in one place for awhile.... Microwave Quote Link to comment Share on other sites More sharing options...
Recommended Posts
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.