Oxygen XML Editor
 
[XML-DEV Mailing List Archive Home] [By Thread] [By Date]

RE: [xml-dev] XML and databases


  • From: "Michael Kay" <mike@...>
  • To: "'Arthur S Bridges'" <Arthur_S_Bridges@...>,<xml-dev@...>
  • Date: Thu, 26 Apr 2007 15:00:22 +0100

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@...]
Sent: 26 April 2007 14:27
To: xml-dev@...
Cc: arthursb73@...
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
Arthur_S_Bridges@...



[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index]
 
© 2002-2008 SyncRO Soft Ltd. All rights reserved. | Sitemap | Privacy Policy
This website was created & generated with <oXygen/> XML Editor
Keywords
xml