Ok, this may be a stupid question, but when choosing a data storage method (XML vs. SQL) what is the best method to store large amounts of text?
I've got a scenario where I will have 30,000+ Businesses in a database and each Business will have at least one report of considerable length. I'm currently storing every report as an XML document with a naming convention that is the same as the business ID. I considered using SQL to store each report as a glob of XML, but the XML documents may exceed the 8000 character limit of a SQL field. Is there something larger than that field or is it more advisable to use XML documents for each report? Each XML Document at their smallest will be appx 6-8k, at their largest will be < 30k. Is it advisable to stuff the XML contents into a SQL table instead as storing as XML files? Any insight appreciated. Thanks, Joshua Miller ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com 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
