XML to Query Timeout

[unleashed]

I'm trying to convert an XML document into a query but it keeps timing out. It's only processing like 1 record every 10 seconds.

My XML document is 1.7mb, the node has 16k records, but only about 400 records need to be inserted into the query.

Is there a more efficient way to do this?

Thanks,

James
Sacramento, CA


Here is my code:

[JR__Bob__Dobbs-qSBHQ2]

What are you going to use this XML for?

You might use XMLParse() to get an XML object instead creating your own query object.

[unleashed]

I'm just trying to extract the GPS (Lat, Long, Speed) data out of the XML document and display it into a webpage or an excel document.

I'm already using XMLParse to parse the XML file.

On a side note, if I comment out the "cfif StructKeyExists" code block, and add in a <cfoutput>#i#<br></cfoutput>, the page renders completely in 3 seconds.

[Guest]

Short answer: Use an XSL transform. It's easier, MUCH faster, and you can use two different XSL stylesheets - or one larger stylesheet - to render the same data as HTML or to load it into an Excel spreadsheet.