Linked by Thom Holwerda on Mon 30th Jan 2012 20:39 UTC

Thread beginning with comment 505839
To view parent comment, click here.
To read all comments associated with this story, please click here.
To view parent comment, click here.
To read all comments associated with this story, please click here.
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.