"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote:

<<Absolutely correct.  He needs to do exactly as you stated, otherwise he
<<won't be getting the benefit of the transaction.

Yeah, I had actually done that first, but when I was switching back and forth trying stuff, I didn't put it back, but I had ran it with the 'Test' value set correctly. As it turns out it was not the
insertions, it was the iteration through the xml doc (IXMLDOMDocument MSXML Type Lib 2.0). I had timed that earlier, but not when I got up in size in the xml input, and around 20,000
records it starts to slow down. I'm not sure if I'm using the correct methodology for node iteration (for each parent, for each child is what I'm doing more or less, I've tried both while <> nil,
next node, and for i := 0 to nodeList.Length), but it's SLOW with 50,000 records.

I did a text file parsing procedure to parse based on the tags, and it was like 15 seconds to load up the 50,000 into the table that way. Good old fashion string/text file parsing

Thanks for the help folks.