Peter J. Holzer [PJH], on Monday, April 11, 2005 at 09:56 (+0200) wrote: PJH> Consistency: Do you need to ensure consistency between this data and PJH> other data? If you store data in files, then somebody can remove or PJH> alter the files without updating the meta-data in the database.
yes, I agree with your post completely too. In my case all files will be local, and from my point of view it is better store images in database. PJH> Centralized access: If everything is in the database, you can either PJH> access all the data or none of it. If you have some data outside of the PJH> database, you may not have access to this data. Agree. I want access all the data, or none. I think safer is storing them in db, you can't delete it by fault (remove files). PJH> Decentralized access: Sometimes it is useful to be able to access the PJH> data without the database (e.g., you may want to access individual PJH> documents via the file system. This is not my case. PJH> And finally, performance: PJH> RDBMs are generally optimized for lots of small data items which are PJH> organized into tables. Filesystems are generally optimized for larger PJH> data items organized into trees. There is considerable overlap where PJH> neither has a clear advantage, and of course it varies depending on what PJH> RDBMS and filesystem you use. hm, in my case I will store <3kb images and I think they will be many files (50.000+). I use freebsd/mysql. -- ...m8s, cu l8r, Brano. [IBM: INTEL's Big Mouth]
