Re: openxml question

Yes the arguments are pretty much the same. Other than adding XML data type
support, I'm not aware of any changes to the inner workings of OPENXML. If
you're using SQL 2005, you might try using the nodes() method of the XML
data type to shred your XML data instead.

<DAXU@xxxxxxxxxxx> wrote in message
news:7da00930-9135-4ea6-9438-b2276eccdc1e@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hello,

I read a document from MSDN saying that:
Avoid OPENXML over large XML documents.
Avoid large numbers of concurrent OPENXML statements over XML
documents.


But my question is: how to define large? Is there some suggestion
saying for example that a 100kb xml file will be too big? Or 100
concurrent openxml will be to match for the system?

The document on msdn can be found at:
http://msdn2.microsoft.com/en-us/library/ms998577.aspx

The document was written in 2004. Are the arguments valid for both sql
2000 and 2995?

Many Thanks

Jerry



.

Relevant Pages

  • Re: XML Buffer, OPENXML Usage Advice
    ... The memory available for OpenXML is 1/8th of available server memory (I ... >attempting to replace some looping processes with batch processes. ... but so far the XML passed into the proc has been less than 2KB ...
    (microsoft.public.sqlserver.xml)
  • can openxml write multiple fields - 1 row?
    ... quantity attributes from the XML document. ... declare @doc varchar ... FROM OPENXML ... This routine only generates one int ...
    (microsoft.public.sqlserver.xml)
  • Re: openxml seemingly fails to process external entity
    ... > External entities are not supported with OpenXML for a variety of security ... > Best is to resolve them on the client/midtier side before sending the XML to ... >> Here are the beginnings of the lines I see in SQL Query Analyzer: ... >> You can verify that this external entity stuff is done properly by opening ...
    (microsoft.public.sqlserver.xml)
  • Re: openxml question
    ... Avoid OPENXML over large XML documents. ... Avoid large numbers of concurrent OPENXML statements over XML ...
    (microsoft.public.sqlserver.xml)
  • Re: openxml seemingly fails to process external entity
    ... External entities are not supported with OpenXML for a variety of security ... Best is to resolve them on the client/midtier side before sending the XML to ... here is some SQL that correctly processes some XML that does ...
    (microsoft.public.sqlserver.xml)
Loading