Re: Large XML file processing via XMLTABLE

If it can be handled by SQL and XML-SAX there's no reason it can't be handled by XML-INTO - and it requires a lot less logic than XM:L-SAX.


Jon Paris

www.partner400.com
www.SystemiDeveloper.com

On Feb 22, 2019, at 4:56 PM, John Yeung <gallium.arsenide@xxxxxxxxx> wrote:

On Fri, Feb 22, 2019 at 4:28 PM Richard Schoen via RPG400-L
<rpg400-l@xxxxxxxxxxxxxxxxxx> wrote:

I would imagine that Python, PHP or Java on IBMi would handle this OK as well.

Java's certainly worth a try. My personal experience has been that
Python on the PC is significantly faster than Python on the i. I
suppose part of that could be that our i is on the wimpy side by
today's standards.

In any case, regardless of speed, I believe all of those languages
support SAX parsing fairly easily, and can talk directly to the
database. Especially if this is going to be a recurring thing, where
huge XML files are automatically deposited on the i, these are worth
looking at. Also, there is the PASE port of Mono, so .NET languages
are a possibility as well.

But, being as this is the RPG list, I suppose XML-SAX is probably
going to be tried before exploring whole other languages. I will say
that I would expect XML-SAX in RPG to be faster executing than SAX in
other languages. But if you don't already know how to do it in RPG, it
would probably be easier to implement in almost any other language.
And who knows, maybe Java would actually perform competitively.

John Y.
--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: https://amazon.midrange.com