Re: DataSet.WriteXML Vs. SQL Server 2000 XML performance issue???

Hello manoj241176@xxxxxxxxx,

There are a lot of different things that affect the performance. Its difficult to determine exactly from this set of minimal description. Have you tested the performance locally?

Thanks,
Shawn Wildermuth
Speaker, Author and C# MVP
http://adoguy.com

Hi,
I have concern regarding two approaches to decide,
1>DataSet.WriteXML
2>SQL Server 2000 to return XML from stored procedure.
With Second approach, I have to open Cursor's and nested stored proc
calls and have to create temporary tables. while in first approach I
dont have to create all this.

So please suggest me, out of these two approaches which will be faster
and will affect performance??

Thanks,
Manoj


.

Relevant Pages

  • Re: XML INTO SQL
    ... stored procedure might be better because I can call it when the xml ... file hits our server rather than scheduling it because the file name ... But when you ask "when the files hits the server" I have to ask: ... that process simply read the file and pass the XML document? ...
    (comp.databases.ms-sqlserver)
  • DataSet.WriteXML Vs. SQL Server 2000 XML performance issue???
    ... 2>SQL Server 2000 to return XML from stored procedure. ... dont have to create all this. ...
    (microsoft.public.dotnet.framework.adonet)