4 ms·
> if each user action that triggered a one cell update becomes an event I have to keep forever, I see my database size exploding Yes I could see that getting p
by fleitz 13y ago
> if each user action that triggered a one cell update becomes an event I have to keep forever, I see my database size exploding
Yes I could see that getting prohibitively expensive when SSDs cost 70 cents/GB and hard drives 5 cents/GB. You should really throw out your historical data at those kinds of costs, probably not worth 5 cents per GB.
Personally, that's why I don't keep backups, files change all the time, and I was going broke making sure I had older copies of my data. I'd rather just rewrite all my code and retake all my pictures.
- buerkle 13y agoHardware cost is hardly the only cost. Managing a few GBs of data is quite a bit different than managing 100s of GBs or more of data.
- fleitz 13y agoPerhaps 100s of TBs but 100 of GBs is not a difficult problem to solve, perhaps once you get to more than 100 TB you'd be beyond the capabilities of a single chassis. Even a petabyte should fit in a rack or two. I really fail to understand how a business could acquire that much data and not be able to sell it. http://blog.backblaze.com/2013/02/20/180tb-of-good-vibrations-storage-pod-3-0/ http://blog.backblaze.com/2013/02/20/180tb-of-good-vibration... Here ya go, 180 TB for $10K in 4U, which means 10 to a rack which means 1.8 PB per rack. Who has 180 TB of database that isn't worth $10K?
- fusiongyro 13y agoHi, I work in astronomy.
- coherentpony 13y agoHi, I work in computational fluid dynamics.
- buerkle 13y agoAgain you need to look at more than the cost of hardware, that's not the issue. More data requires more managing; performance, backup, failures, etc