Parsing large XML file

[john316swan]

I am reading an xml file from an sftp server, no issues, but when I select the xml parser, it takes so long that there is a timeout. Here is a screenshot of how I setup the snap:

It should not take this long to parse this out, what am I doing wrong?

[john316swan]

There are 364,507 rows in the xml file.

[ptaylor]

I see you already set the Splitter property -- that's good. In the Pipeline Execution Statistics, do you see lots of output documents as the file is parsed? If you validate the pipeline, is the output what you expect?

[ptaylor]

You'll have to change Snap Execution to Validate & Execute to test validation.