I have a document imaging system I wrote with CF, with all Tiff formatted images. I stored all documents in a folder structure like this:
\company\cabinet\YYYY\MM\DD\filename.tif This makes a nice directory structure that you can backup date periods or archive a month or year very easily, and the directories don't get so bloated you cannot browse them. I store the files in the filesystem vs the database simply because if the DB is lost, I can still get my files =) I have over 3 million images and my system is working great for 3 companies so far! Chris Peterson -----Original Message----- From: E C list [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 23, 2006 8:14 AM To: CF-Talk Subject: Storing lots of files Hello, I was looking for some advice on the best way to deal with thousands of files (PDFs or TIF files of contracts and paper relating to the contracts) using ColdFusion 5.0. Here is the scenario: We are purchasing a sharp copy machine that is networkable. One of the best features of this machine is that it will email scans of documents to an email address. What I plan to setup is a system whereby when a salesman brings in a contract, s/he puts it in the copy machine, and sets it to email a copy of the document to an email address monitored by ColdFusion. In the subject line, they will put in a unique ID for that customer and possibly a description code (ie- Contract, Check, Material Order, etc...). ColdFusion will pick up the email message, do something with the file attached and pop at least the description into the database with the customer's ID number to key it against the customer's record so that it could be retrieved remotely as needed. The question I have is what is the best way to handle those documents on the server? Should they be stored as files in a single directory (Windows 2003 Server), should they be put in some kind of subdirectory system, or should they be inserted into the database? If the later, can anyone give me an idea or point me to a resource that would describe how this is done with ColdFusion 5, as I haven't ever actually done any work where files are kept in the database. Thank you! --------------------------------- How low will we go? Check out Yahoo! Messenger's low PC-to-Phone call rates. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250708 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
