You are going to use more physical disk space storing the PDF's in the DB than if you store them as physically files on the drive.
-----Original Message----- From: Jared Rypka-Hauer - CMG, LLC [mailto:[EMAIL PROTECTED] Sent: 03 March 2005 15:24 To: CF-Talk Subject: Re: MSSQL TEXT datatype problem with CF No, I didn't... but that's a great idea. I was using the long-value columns in SQL Server because the site I was doing needed secured storage for the PDFs (they're fairly private contract documents - high but not mission-critical security needs) but thru the host at the time I didn't have access to any folders outside the webroot. So rather than mess with the ISP, I just stored them in the DB... and it worked great. Access was actually faster than it is on the new ISP's server using cffile action="read" even though I was moving 1.5MB of text out of the DB and converting it from base64 data back to binary and then to string data. However, the new ISP only alotted 50MB of data storage in SQL Server and did provide a context on the web server that basically puts the webroot of the site inside my FTP root, so I had to pull the PDFs out of the database and put them in a directory. It's a little easier to work with, but it's not quite as fast. I'm not sure why, but I never looked at a proper BLOB field, just a CLOB field, for storing the PDFs. Maybe I just latched onto the first idea I had. Other than the size of the files in the database, though, it worked amazingly well. Laterz, J On Thu, 3 Mar 2005 07:12:04 -0600, Dawson, Michael <[EMAIL PROTECTED]> wrote: > Did you ever try storing the files in an Image data-type? I'm not sure, > but I would guess that would not require the files to be converted to > text before storing them. > > M!ke > > Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=15114.13525.4 > Donations & Support: http://www.houseoffusion.com/tiny.cfm/54 > -- Continuum Media Group LLC Burnsville, MN 55337 http://www.web-relevant.com http://cfobjective.neo.servequake.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197246 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
