Not if you use BFILE data types with Oracle. Unlike BLOBs or CLOBS which store a pointer in the column to data that is managed separately in the database, BFILEs are pointers to external files. Thus you get the convenience of the pointer in your column without the performance penalties.
-Matt > -----Original Message----- > From: Dick Applebaum [mailto:[EMAIL PROTECTED]] > Sent: Monday, May 06, 2002 12:10 PM > To: CF-Talk > Subject: Re: storing files in DB > > If you mean storing images/text files, etc. in blobs or large text > fields; rather tha just storing the file path... it is generally a very > bad idea. > > You gain a little convenience (referencing files) but pay a huge penalty > in performance and db overhead. > > Dick > > > On Monday, May 6, 2002, at 10:00 AM, Wajid Hussain wrote: > > > Hi guys, has anybody come across writing/reading files to a db? any > > advice will be much appreciated. WAJ. > > > > > > > > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
