The problem is simply the size and cost of the indexes etc.... they all add up to unnecessary usage.
-----Original Message----- From: Jared Rypka-Hauer - CMG, LLC [mailto:[EMAIL PROTECTED] Sent: 03 March 2005 16:06 To: CF-Talk Subject: Re: MSSQL TEXT datatype problem with CF Indeed... I could tell. I ran an export of the DB into a local replica sans the PDF column... the data file went from 198MB to 4MB. Twas a telling test. But still... there are situations where eating up disk space with a DB data file isn't a "waste" so much as a "cost." The point was mostly just that a) it could be done and works nicely and b) the perceived performance of reading 1.5MB of text out of a database and converting it back to the right format was FASTER (by quite a bit, actually) than using CFFILE and a folder outside the web root. I say "perceived performance" because I didn't actually do any performance testing... I refer to user experience. The DB-driven solution returned activity to the user's screen faster by a second or two than the CFFILE version doing basically the same thing. That, considering that cffile is reading from the local hard disk and the DB solution was over-the-wire to a busy SQL Server, is actually quite the fascinating factlet. Laterz, J On Thu, 3 Mar 2005 15:22:46 -0000, Robertson-Ravo, Neil (RX) <[EMAIL PROTECTED]> wrote: > 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. > > -- Continuum Media Group LLC Burnsville, MN 55337 http://www.web-relevant.com http://cfobjective.neo.servequake.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197273 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
