Peter I've never stored documents in a DB so I can't give you much of a performance comparison. I've always just stored the documents in the file system and metadata in the database. But the few times I have needed to do this have been very small systems.
One of the biggest differences between these methods is synchronization. When the file is stored on the file system and the metadata in the database it is much easier for disconnects to occur because at some point somebody adds|moves|renames|deletes a file outside of the document management system. Now there is a difference between the records in the database and the files on the file system. If one is to put the file itself into the database this kind of synchronization issue is much less problematic. But as with most programming problems, YMMV and one must decide on what is best for the problem at hand. -------------- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA --------- | 1 | | --------- Binary Soduko | | | --------- "C code. C code run. Run code run. Please!" - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241981 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
