Here is the article I wrote on the subject, http://www.devx.com/xml/articles/ml062502/ml062502-1.asp. The article does include some reasons why you would want to use an XML database of an RDBMS for XML storage.
Matt Liotta President & CEO Montara Software, Inc. http://www.montarasoftware.com/ V: 415-577-8070 F: 415-341-8906 P: [EMAIL PROTECTED] > -----Original Message----- > From: Dick Applebaum [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 15, 2002 9:33 PM > To: CF-Talk > Subject: Re: XML vs. SQL with large amounts of text > > Have a look at Xindice -- an XML database: > > http://xml.apache.org/xindice/ > > I understand that both Matt Liotta and Tom Dyson have interfaced Xindice > with CFMX. > > Dick > > > On Thursday, August 15, 2002, at 08:24 PM, Joshua Miller wrote: > > > 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 > > > > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm 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
