"'Arthur S Bridges'" <Arthur_S_Bridges@progressive.com>,
<xml-dev@lists.xml.org>
cc
<arthursb73@gmail.com>
Subject
RE: [xml-dev] XML and databases
25,000 records x 12 fields x 20 bytes = 6Mb which
is certainly doable using
a single XML document loaded into memory, unless you need fine-grained
transactional updates and concurrency etc. Multiply by 10 and you're
straining it a bit. I think I'd go for an XML database.
Michael Kay
http://www.saxonica.com/
_____
From: Arthur S Bridges [mailto:Arthur_S_Bridges@progressive.com]
Sent: 26 April 2007 14:27
To: xml-dev@lists.xml.org
Cc: arthursb73@gmail.com
Subject: [xml-dev] XML and databases
I am working on a large data classification dictionary
in XML and I am
wondering at what point do I need to use a database as a back end.
Project Profile:
From a 'table' point of view, I have about a dozen fields and 25,000 records which we project to grow to 250,000+
Each record contains resource profiles and descriptions as well as ownership information which needs to be kept up to
date with personnel
changes. We plan to use XQuery/XSLT as well as C# for access/update
programming
Has anyone out there had to deal with a project of
this size?
We are planning to run a web service fro Query and
update functions.
Thank you for any response and Suggestions
Arthur Scott Bridges
IT Security - SCD <mailto:Arthur_S_Bridges@progressive.com> Arthur_S_Bridges@progressive.com
[attachment "C.htm" deleted
by Arthur S Bridges/Guest/Progressive]
