Author:  matthewcrandall  Posted:  Dec 11, 2010 12:09  Subject:  Re: Stop purging data  Viewed:  54 times  Topic:  Suggestions Cancel Reply

BrickLink ID Card matthewcrandall (83) Location:  USA, Oregon Member Since Contact Type Status Feb 11, 2007 Buyer

In Suggestions, locutis writes:    In Suggestions, Reki_Lobsheek writes:    as nobody else seems to ask this, I will: to what purpose? I mean, I wouldn't mind if promise could be made it wouldn't slow down the website, but I'm just wondering why it would be necessary? Reki Instead of deleting the data, they could archive it like I have, and move it to another database. Set a script to run and archive it to an alternate database. If you want access to the archived information, have it come from the archived database, which gets a lower priority on the processor then current data. Why keep data, why not? The storage of a database for the data is nearly free (500 GB hard drives are $40 currently, and can hold decades of database text data). Okay, I'll play along... Why keep some of this archived at all? What purpose does it serve? I'm not against archiving data; but let's look at what gets archived first. Just about everything here is considered data. Off-topic stuff, bad jokes, "cancelled" replies to topics, and "Hi I'm a new person" entries...is there really a need for that after say, nine months to a year? Catalog changes and additions...sure. Those need to be kept. But a lot of that gets looked at, so it should remain on the main server. That's a lot of entries right there. I'm not sure how it works, but store inventories probably exist somewhere, too. Then there's the questions that come up: how often do you move stuff to the archives? Annually? Quarterly? And, there has to be a way to access and search those archived items easily. That takes a little time; each item has to have a separate entry to be totally searchable. Yes, I know you can set a script to run the transfer. But there has to be a script ready to go, or it has to be written. Yes, I understand memory is cheap these days. But it still has to be purchased, installed, configured, and those items archived moved and made accessible...and all without disrupting service so that everyone doesn't have a fit. (I would say this time of year would be a bad time for the service to be down for more than an hour, for example.) I'd rather have faster processing server(s), and some very selective pruning of data. Where I sit, that pays better dividends in the long run. Play Well and Prosper, Doc Crandall "The Brick Detective"

Message is in Reply To:

Re: Stop purging data - Locutis (69)

[...] Instead of deleting the data, they could archive it like I have, and move it to another database. Set a script to run and archive it to an alternate database. If you [...] (164 months ago, Dec 11, 2010, to Suggestions)

19 Messages in this Thread:

 Msg 1 - Timothy_Smith (1537) 164 months ago Dec 11, 2010 to Suggestions
 Msg 2 - legomadsteve (72) 164 months ago Dec 11, 2010 to Suggestions
 Msg 3 - redbeardlegoman (83) 164 months ago Dec 11, 2010 to Suggestions
 Msg 4 - JoeMomma (1214) 164 months ago Dec 11, 2010 to Suggestions
 Msg 5 - bb166186 (89) 164 months ago Dec 11, 2010 to Suggestions
 Msg 6 - Timothy_Smith (1537) 164 months ago Dec 11, 2010 to Suggestions
 Msg 7 - Locutis (69) 164 months ago Dec 11, 2010 to Suggestions
 Msg 8 - AggieSava (992) 164 months ago Dec 11, 2010 to Suggestions
 Msg 9 - Locutis (69) 164 months ago Dec 11, 2010 to Suggestions
 Msg 10 - Locutis (69) 164 months ago Dec 11, 2010 to Suggestions
 Msg 11 - Reki_Lobsheek (2465) 164 months ago Dec 11, 2010 to Suggestions
 Msg 12 - Locutis (69) 164 months ago Dec 11, 2010 to Suggestions
 Msg 13 « - matthewcrandall (83) 164 months ago Dec 11, 2010 to Suggestions
 Msg 14 - Brickwilbo (1534) 164 months ago Dec 11, 2010 to Suggestions
 Msg 15 - Rbobo (3014) 164 months ago Dec 11, 2010 to Suggestions
 Msg 16 - wahiggin (2868) 164 months ago Dec 11, 2010 to Suggestions
 Msg 17 - eileenkeeney (1610) 164 months ago Dec 12, 2010 to Suggestions
 Msg 18 - tomte (82218) 163 months ago Jan 30, 2011 to Suggestions
 Msg 19 - BLUSER_228233 (114) 163 months ago Jan 30, 2011 to Suggestions