[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] RE: XML and databases
Unfortunately, the company's preferred platform is SQL Server, but with v 2005's XML capabilities, we may make it work. Also just rechecked, 18 fields and many descriptions are detailed. - 11 Mb - Arthur Scott Bridges IT Security â SCD Arthur_S_Bridges@p... Mayfield Village , Ohio , 44143 USA This http://microformats.org/wiki/hcard
created with the http://microformats.org/code/hcard/creator.
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@p...] Sent: 26 April 2007 14:27 To: xml-dev@l... Cc: arthursb73@g... Subject: 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@p...> Arthur_S_Bridges@p... [attachment "C.htm" deleted by Arthur S Bridges/Guest/Progressive]
[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] |
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|