DB versus flat file performance
Posted: Sun Sep 03, 2006 9:12 pm
I've have read numerous forum threads over the last couple years of people debating the performance of storing files inside a database as opposed to the native file system...
http://www.mail-archive.com/struts-user ... 18853.html[^]
Here is one such debate...
I'm wondering if anyone knows any others...?
It seems to me that storing files on the file system as opposed to a database would be more efficient as file indexing, etc is performed at the kernel level...
Some databases might capitalize on RAID, etc...but still I would personally think native file system indexing would win hands down when both tweaked for performance, especially on a linux system with all it's available file systems?
I'd like articles (more credible the better) but just your opinions or experiences would be awesome as well
Cheers
http://www.mail-archive.com/struts-user ... 18853.html[^]
Here is one such debate...
I'm wondering if anyone knows any others...?
It seems to me that storing files on the file system as opposed to a database would be more efficient as file indexing, etc is performed at the kernel level...
Some databases might capitalize on RAID, etc...but still I would personally think native file system indexing would win hands down when both tweaked for performance, especially on a linux system with all it's available file systems?
I'd like articles (more credible the better) but just your opinions or experiences would be awesome as well
Cheers