advantage and disadvantage of xml over recordset

  • could any one show me a practical example that xml has advantage over recordset?I think xml is slow and increase  network traffic.

  • With XML you can return many recordsets (say a complex hierarchy) in a single xml document, a single database hit.

  • To me the greatest benefits are three:

    1. Eliminate a hit against the SQL database. This is good for datasets that you can afford to update on a scheduled basis, such as once a day.

    2. XML is ideal for hierarchical data sets. If you have an application that uses these, you can take advantage of storing that data in an XML document.

    3. XML is easy to program against in most languages, including .NET.

  • thanks a lot.I got the idea!

  • yousef,

    It is my understanding that one of the primary benefits/advantages of XML is that the data can be interpreted by a wider range of client apps much easier than the same data in a recordset.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply