MS SQL XML - SQL Server 2005 & XML performance question

Author

SQL Server 2005 & XML performance question

Jon

2005-10-27, 9:26 am

Hi,

I'm designing a very large-scale application and have identified XML as an
ideal mechanism for storage because my data is structured, but likely to have
ongoing structural changes.

I don't know if the XML data types and technology in SQL Server 2005 are
going to offer good enough performance. Here's my question. Let's say that
one XML doc has the equivalent of about 4,000 records. If I index the XML
fields and then run a query that matches against a single attribute in the
XML doc, does the query have to return all the XML content to the client? If
it's a huge XML file, that seems extemely slow compared to searching a data
structure of relational 4,000 rows where a query would have to return only 1
row when a match is found.

Can anyone with knowledge of XML and Ssql Server 2005 help guide my thinking?

Kent Tegels

2005-10-27, 9:26 am

Hello Jon,

> Let's say that one XML doc has the equivalent of about 4,000 records.
> If I index the XML fields and then run a query that matches against a
> single attribute in the XML doc, does the query have to return all the
> XML content to the client?

Nope. If you use the .Value method to get that attribute's value, it returns
the requested SqlServer Data type.

Thanks!

Kent Tegels
DevelopMentor
Blogging @ http://staff.develop.com/ktegels/

Michael Rys [MSFT]

2005-10-27, 9:26 am

I would also recommend to check out some sample code I have on my weblog at
http://sqljunkies.com/weblog/mrys (go to the articles) to get you started
with playing with the functionality.

Best regards
Michael

"Kent Tegels" <ktegels@develop.com> wrote in message
news:bc59bc314de868c
7a37e7c66cad0@news.microsoft.com...
> Hello Jon,
>
>
> Nope. If you use the .Value method to get that attribute's value, it
> returns the requested SqlServer Data type.
>
> Thanks!
>
> Kent Tegels
> DevelopMentor
> Blogging @ http://staff.develop.com/ktegels/
>
>

Sponsored Links