storing a million of small files Oracle (or other db) vs. File System

this was supposed to be cross-posted..
you can check out a thread (under same subject) on comp.unix.solaris :)

Trying to figure out pros and cons of storing a million (and growing) files ranging from 1k to 500K (mostly text, possibly multimedia soon)

Files can get inserted on the order of 15-20/sec

Oracle:
pluses
* storing in LOBs all in one place, don't have to worry about file
system, don't have to worry about recovering both DB and File System in case of file system problems
minuses
* bloated database, extra redo/rollback generated, larger backups

File System
pluses
* easy managability for experienced Unixer
minuses
* not easy for inexperienced, File System OS might need to be tuned to
accompany millions files in single dir.

e.g., recently a delete of 64K files took a good few hours to complete

Suggestions? Previous experience? Received on Fri Jun 22 2001 - 07:46:41 CDT