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
>
>
______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
