I added the second parse().
Parse 1 is processing the entire XML with the embedded escaped XML.
Parse 2 is the XML that has been unescaped by the first parse() into a single field.
Why is the first parse taking so long ?
The second parse has the same data, about 95% of the first parse but unescaped.
12:46:08.222 XML Times for 40374 items = 50 <---- total bytes and # of items
12:46:08.234 XML parse 1 = 3551 <---- time is in MS ( 3.5 seconds )
12:46:08.244 XML scan 1 = 7 <---- time shows that there are very few fields
12:46:08.254 XML parse 2 = 66
12:46:08.265 XML scan 2 = 287
12:46:08.274 XML setup = 76