First and foremost, any feedback at all is much appreciated. Well, I know I phrased my question inappropriately. What I really want to know is: If anyone has ever attempted to store files in the database (files such as .pdf, any image files, word documents, text files, cad drawings, you name it files.)
If anyone has successfully done so. If anyone made attempts and was either not successfull, or could not satisfied with that implementation. If they were not successful, if it was due to any limitations of the db driver or limitations with coldfusion. Our current application stores the files in the db and does not have any performance problems, but then we do not have over 100 simultaneous users and probably never will. Let me provide some background to the reason why I am investigating the storage of all the client's file in the database rather than the I am aware that there is a significant effect on performance when storing images and files in the database. First of all, it takes longer to retrieve and second, it is an additional hit to the database. But performance is not our main priority, protecting the files from tampering is. I understand that the files can be stored on the disk and protected through OS security or some security mechanism such as LDAP, but that is a maintenance nightmare. The problem with the solution of storing the files out to disk is that it requires so much more technical support because then we have to constantly maintain the security on all the systems that we install on. Second, we do not always have full rights to the os that the clients install our application on because some clients do not like giving that priveledge to external entities. This makes it tough to ensure that the proper rights are implemented. We could just write up security requirements and place the liability on client, but when they corrupt their files because they did not follow our directions, then they blame us. Even when they don't blame us and realize it is their mistake, our tech support team is required to repair the problem. Storing the files in the db requires much less effort in protection of the files. ===== Suzanne Capener Allaire Certified ColdFusion Developer Allaire Certified ColdFusion Instructor Infovision Inc. aka - [EMAIL PROTECTED] Looking to certify go to www.cfcertification.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
