>a lot of folks find that storing files on the file system and >then linking the filename in the database works well.
Yes, when I got hit with this first thing this morning that was one of the quick-fix options I gave them. As you surmised I would much, much rather store everything in the db and then, under most circumstances, publish static html pages so there's no cf or db load. Something like this, pumping out *that* much data would definitely benefit from static page display. Bah. The site launches in something like 4 hours. Great time to get hit with a new requirement that wants the core db files re-spec'd. ------------------------------------------- Matt Robertson, [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com ------------------------------------------- ---------- Original Message ---------------------------------- From: "Jim Davis" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Thu, 3 Jul 2003 15:43:07 -0400 >I prefer to store everything in the DB (as obviously you do as well) - but a >lot of folks find that storing files on the file system and then linking the >filename in the database works well. > >At the very least it would improve DB performance if that's you're main >concern. > >Personally I'd rather be able to back up only the DB and have all my data >however... but the choice is there. > >Jim Davis > >> -----Original Message----- >> From: Matt Robertson [mailto:[EMAIL PROTECTED] >> Sent: Thursday, July 03, 2003 3:37 PM >> To: CF-Talk >> Subject: Limit to how much form data can be submitted? >> >> Thanks Jim, >> >> At least thats not a brick wall to this client solution. Apparently these >> guys generate statistics every other day or so, and somehow locally export >> them to html that is tagged with a Front Page 4.0 generator tag. Then >> they want to paste same into an ActivEdit window. >> >> If I can't talk them into some sort of direct data export/import the next >> hurdles are enlarging cf's data buffer (this is CF 4.5. Not sure if I >> need to do this) and assessing whether or not using one of mySQL's longer >> longtext fields will torpedo performance. >> >> --Matt-- >> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
