Re: Large XML file processing via XMLTABLE

[Henrik Rützou <hr@xxxxxxxxxxxx>]

Hi Paul

is there any reason for the following statements uses relative Xpath
instead of named Xpath?

              mailingNumber varchar(5)   default ' ' path '../../MailingNumber'
            , imbNumber     varchar(21)  default ' ' path '../IMB_Number'

They may cause some processing overhead.

Just an idea

On Sun, Feb 24, 2019 at 7:40 AM Richard Schoen via RPG400-L
<rpg400-l@xxxxxxxxxxxxxxxxxx> wrote:
> As a test of the new native Mono .Net environment on IBMi, I wrote a little C# console app to shred a sample 29mg XML file and write to a CSV file.
>
> The program runs on my laptop in 3 seconds.
>
> The same exact EXE copied to IBMi ran for about 45 seconds. (Pase Env)
>
> Not bad for a native .Net app.
>
> Regards,
> Richard Schoen
> Director of Document Management
> e. richard.schoen@xxxxxxxxxxxxxxx
> p. 952.486.6802
> w. helpsystems.com
>
>
>
>
>
> --
> 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