General Q: XML vs traditional SQL datastores

  • Thread starter Thread starter Martin Knott
  • Start date Start date
M

Martin Knott

Hello,

I'm in the process of looking for a host for my site. The host I like
the look of (firestorm.ch) charges more for MySQL or MSAccess databases.
I don't plan at this stage to host large amounts of data and I guess I
could always upgrade if I needed to, but as a general rule are there
major performance or other advantages to using these dbs over just using
XML files?

The only thing I think I might miss is stored procedures. Balanced
against that is the ease of transferring xml files if I decide to
populate from an alternate source.

Any good discussions on this issue?

Cheers.
 
if you can manipulate the data to your satisfaction using xml, and you take
advantage of the caching features of asp.net when you can then there would
be no reason why small scale data couldn't be handled this way.

--
Regards

John Timney
ASP.NET MVP
Microsoft Regional Director
 
This could work fine for small sets of data.
If you start getting into larger, read/write, relational stores of data on a
high volume site then you'll start to feel the pain of XML and wish you'd
gone with SQL Server.
 
Back
Top