XML and Database, which faster ?

[Anon]

Let's a website allow visitor to submit
article.

This article will store in database and also
in a XML file. Both XML and Database contain
the same information.

Do you think load the article from Database
is faster than from Xml file, or reverse ???

OR XML just merely for document/information
exchange ????

[ionzoft]

Generally Speaking...

An INDEXED database is faster than XML on a local machine. Also, you will find that storing article's in a DB will allow a great deal of power in the areas of searching and maintenance. XML is great for document exchange because of it's generic format, but in your case, a DB like MySQL would suit better.

Mike the edge wrote:

Let's a website allow visitor to submit
article.

This article will store in database and also
in a XML file. Both XML and Database contain
the same information.

Do you think load the article from Database
is faster than from Xml file, or reverse ???

OR XML just merely for document/information
exchange ????