Ben said: " I'd have to agree with Paul on this one. In one of the new issues of aspNetPro magazine there is an article about storing files in your Database. It is becoming more common to store images, files etc.. in your DB rather than just putting a link to the file. Security is handled by the DB as well so you don't worry as much about setting up secure directories. "
Ben, do you have the details on that issue of aspNetPro mag? Since this will most likely end up using SQL Server that article may be very pertinent. The DB giants (Oracle,MS) obviously offer BLOBs as a datatype for a reason. It has always been my personal practice to store the links to the file in the DB and the actual files in the file system. After reading the comments on both sides here I am beginning to think differently. I am still concerned with the eventual size of the db if I store everything in there. On the other hand using the system in a clustered may pose a problem although I haven't fully investigated how one of the large DB vendors handle replication etc. across the cluster. I agree that storing the files in the DB offers higher level of "protection" of the files and that is a key point as far as I see. Thanks again for all those who have contributed to this discussion so far. It is much appreciated. Best Regards, Donnie Bachan Phone: (718) 217-2883 ICQ#: 28006783 "Nitendo Vinces - By Striving You Shall Conquer" ====================================================================== The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. _________________________________________________________________ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
