Re: openxml question

On Wed, 2 Jan 2008 05:15:40 -0800 (PST), DAXU@xxxxxxxxxxx wrote:

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?

No, I think not.

On SQL2005 (!), I've used openxml to process two megabyte files on a
tiny, overloaded laptop, I run five or ten nodes queries to shred it
in two seconds, and that's pretty darned good performance in my book!

Maybe 20mb would be a problem, or 200mb. Assume it does keep
everything in RAM, but tokenized. Also even small systems today do
have gigabytes of RAM, which may be wasn't so true even four years
ago.

J.

.

Relevant Pages

  • openxml question
    ... I read a document from MSDN saying that: ... Avoid OPENXML over large XML documents. ... Avoid large numbers of concurrent OPENXML statements over XML ...
    (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)
Loading