Linked by Thom Holwerda on Mon 30th Jan 2012 20:39 UTC
Permalink for comment 505839
To read all comments associated with this story, please click here.
To read all comments associated with this story, please click here.
News
Linked by Thom Holwerda on 05/20/13 22:43 UTC
Linked by Thom Holwerda on 05/20/13 21:50 UTC
Linked by Thom Holwerda on 05/19/13 23:15 UTC
Linked by Thom Holwerda on 05/19/13 23:11 UTC, submitted by Drumhellar
Linked by Thom Holwerda on 05/18/13 21:06 UTC
Linked by Thom Holwerda on 05/18/13 7:37 UTC
Linked by fran on 05/18/13 1:38 UTC
Linked by Thom Holwerda on 05/17/13 23:35 UTC, submitted by kragil
Linked by MOS6510 on 05/17/13 22:22 UTC
Linked by Thom Holwerda on 05/17/13 22:15 UTC, submitted by Tom
More News »
Sponsored Links



Member since:
2011-12-31
I've seen lots of databases, from oracle, MySQL, MS, Sybase...
None of them are any where near as fast as a filesystem.
Try searching blobs for information... VERY slow.
Try locating a blob given just a short name... nope. not gonna find it.
Try searching for all files of that name... Fairly quick at that... depending on how many indexes it has to go through.
Try maintaining metadata (acls, permissions, ownerships..) possible.. but try searching- REALLY slow.
How long does it take to recover? databases have to replay their journals.. can take hours for a database of a couple of GB. Especially if it is updated continuously.
Databases have their place. They are very good at non-structured small units of data. Relational database suck at structured data though - they have to constantly rebuild the structure. SLOW.
Filesystems have been tried in databases (look at sqlfs for one). They can work. But they are really slow.