Re: XML vs SQL Server

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Everyone else has made good points...especially in regards to why you pick a
rdbms to begin with over txt, excel or other files.

My input will be this. You can architect your code so you're now
screwballed in the future if you need to swap out for a different dataStore.
(Aka, when you figure out that xml is too slow because your data grew too
big).

See:
http://sholliday.spaces.live.com/Blog/cns!A68482B9628A842A!176.entry

This shows how to write an interface, and bring back 1 of several concretes
depending on which rdbms you might pick.


....

(Note, I use the term "rdbms" very loosely with backends like Access(Jet
database), Excel and Xml. These are datastores, not really rdbms systems).

...........




"shapper" <mdmoura@xxxxxxxxx> wrote in message
news:709fb04a-767e-4691-ae09-b42a14f2712e@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hello,

When a web application (site) is small in terms of data I usually use
XML files.

For example, at the moment I have a web site with the following XML
files (Note: I use XML as they would be SQL Server tables):

Users, UsersRoles, Roles, Texts, Albums and Photos.

To give you an idea I will have at its maximum:

4 Users, 2 Roles, (8 UsersRoles), 4 Texts, 10 Albums and 200 Photos.

Each photo will have a maximum of 40KB. Most of them only 10 or 20 KB.
The functionality I need is really simple: Create, Delete, Get and
Update. No really complex queries.

Do you think for this kind of project a XML structure to hold data
rather then SQL Server is ok?
Will I have a huge problem in performance?

I have this implemented and it is working quite fine.

Where do you think it is the "point" of using a SQL database instead
of XMl files?

Thanks,
Miguel




.

Relevant Pages

  • Re: Merge from XML
    ... Excel spreadsheet that is sorted and has types defined on the columns (e.g., ... I think I'm still going to take an XML approach as you can import an XML ... using an XSL transform to convert the XML to a format Word can use. ... if you can access SQL Server directly from your workstation you ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Vlookup nightmare
    ... >instead of 'trying to use excel with referential integrity' ... RDBMS is a more efficient way to store data than XML. ... area code and return multiple fields of information: ...
    (microsoft.public.excel)
  • Re: excel or xml
    ... XML documents will be static, you can't edit them or change the formatting ... It sounds like your skill set is with Excel right now. ... or even use Reporting Services to mail reports to users. ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.xml)
  • Re: Architecture question on parsing a large text file
    ... a database in SQL Server. ... If (null!= _excel) ...  If you go the XML route you just save to XML. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Merge from XML
    ... My end users cannot access SQL Server. ... We currently generate an Excel file ... The word 2007 .docx files are stored as XML. ... using an XSL transform to convert the XML to a format Word can use. ...
    (microsoft.public.word.mailmerge.fields)