Re: [KCFusion] storing files

[Jim Hrdy]

Not sure if the layer difference is even in question. Managing files in a database will give the site a higher granularity of content control. Looking at it from a coder and security perspective. By using a oracle, db2 or sql server database to store your files you take a performance hit (depending on how you have configured your database server) on file delivery, but gain quite a bit in content security and delivery options. I think you will find that combining this style of content storage with an application like cold fusion that works and plays well with database servers you would have a rich environment.   ----- Original Message ----- From: Dunwiddie, Bruce To: '[EMAIL PROTECTED]' Sent: Monday, March 10, 2003 11:28 AM Subject: RE: [KCFusion] storing files I don't necessarily disagree, but there's a difference here. We all have to admit that modern operating systems already basically have a database that stores files, it's just that that file system database is very native to the operating system, as compared to a database that is installed on top of that file system and storing files inside it as files that are being stored inside the other, that makes for the inefficiencies. You need to cut back on the layers when you can. Now if something comes along that removes the layer difference between two options, then the inefficiencies no longer is part of the argument. -----Original Message----- From: Greenhagen, Robin [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 11:21 AM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] storing files Actually, putting all the files in the SQL or Oracle DB is exactly where the world is headed.  The next version of Windows Server (after the 2003 version that comes out in 7 weeks) will use MSSQL Server for it's file system.  Oracle already has a bunch of products based on using the DB as your file system, including an explorer interface, etc...    We haven't looked at this since CFMX, but storing the files in the DB in CF 4.x/5.x was a real pain.  ASP/ASP.NET have a lot more finite control over this.   Robin Greenhagen President GSI http://www.gsi-kc.com/