Sorry that this is an off-topic thread, but I know of no other CF community resource for general questions.
I have written a large application for law firms to manage their files and communications. They can upload files (pdfs, docs, etc) and generate then using the system. I have also developed a fully integrated communication component supporting online email and fax, so every email attachment that they send or receive gets stored as well. So basically I have a system with tons of files (about 2GB for this one law firm). Currently I store these files on disk, and keep a reference to them in the database. This has been fine for this one client, but they now wish to take this application to market and build it out under a SaaS model, so some transitioning is going to happen. I am wondering how you guys (and gals) manage files in your applications? Our target is to build this system out to support 200 law firms, at which point we would rebuild the system with SaaS in mind from the start. 400GB of file storage does not seem practical in this case. So how do you folks handle things? Do you typically ZIP uploaded files? Do you use OS directory compression on file storage folders? That would be an easy fix requiring no code adjustment. Do you implement archiving in your application? If so, how do you go about this? Do you store files in the DB? Is this really practical when storage might be 100GB or more? I would think that DB backups would be hell. Any input would be appreciated. -Brian -- You received this message because you are subscribed to Mach-II for CFML list. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/mach-ii-for-coldfusion?hl=en SVN: http://greatbiztoolsllc.svn.cvsdude.com/mach-ii/ Wiki / Documentation / Tickets: http://greatbiztoolsllc.trac.cvsdude.com/mach-ii/
