Re: Index xml in variable

Tech-Archive recommends: Speed Up your PC by fixing your registry

Hello JRStern,

Hi, more newbie questions. When I first read over the SQLServer XML
documentation, I saw you could index XML. I thought this would be
great if you had a big single XML value that you were working on. I
have a 2.4mb XML value now, and yeah, it's running slow, several
minutes to do a cross apply returning about a thousand rows. So I
thought, great time to index!
Only now it seems the indexing is for XML in tables, not in a
variable.
Does it pay to write a single (2.4mb) value to a table with an index?

Yes, probably. Even if it is to a temp table.

Funny thing is, on a very similar XML structure with the same kind of
processing we had concerns about scalability, so a few weeks ago I'd
created a 2.3mb test data, and it ran in about fifteen seconds. I'm
really not sure why this one is different and running about 10x
slower. FWIW, this is on a smallish workstation (laptop), and what I
see is the CPU pegged while it runs, little or no IO.

Have to see your query to tell you with an sense of surety.

Thanks!
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/


.

Relevant Pages

  • Re: Return different row sets using for xml?
    ... queries return the data to BizTalk as a single XML document. ... customers for xml explicit; ...
    (microsoft.public.sqlserver.xml)
  • RE: Multiple DataSets in one XML file
    ... Unless you're taking some special care of XML structure, ... it's up to you to find the right data set start and invoke ReadXml ... Multiple DataSets in one XML file ... > It's very easy to DataSet.WriteXmlmultiple dataset to a single xml ...
    (microsoft.public.dotnet.framework.compactframework)
  • Index xml in variable
    ... When I first read over the SQLServer XML ... you had a big single XML value that you were working on. ... value now, and yeah, it's running slow, several minutes to do a cross apply ... Basically I'm shredding the XML into tables, joining the top level elements ...
    (microsoft.public.sqlserver.xml)
  • Re: PHP/pear http put method and text/xml?
    ... As you insisted in a previous posting that the examples serve as documentation, ... When putting it as a binary, the XML ... > And what message appears when you do HTTP PUT with Python or Java? ... > the response when using the PEAR class? ...
    (comp.lang.php)
  • Re: libxml: is it possible not to use doctype declaration?
    ... am not sure how to conclude that from the documentation. ... those were supposed to be class variables. ... of your xml before trying to parse it, ... Is using libxml the right thing to do to, ...
    (comp.lang.ruby)