Re: Insert and Long Names

[Alan Campin <alan0307d@xxxxxxxxx>]

Yep. Both are coming from a local work file being read using file I/O. The
only difference is that on one inserts long names are used and on the other
short names are used to write to a DDL generated table using SQL inserts.

On Mon, Dec 28, 2015 at 11:06 PM, Norm Dennis <nhdennis@xxxxxxxxxxx> wrote:

> Are you using the same path for both reads?
>
>
> Cheers,
>
> Norm Dennis
>
> -----Original Message-----
> From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Alan
> Campin
> Sent: Tuesday, December 29, 2015 00:42
> To: RPG programming on the IBM i / System i
> Subject: Insert and Long Names
>
> We are doing data conversion of large amount of data and we are seeing
> very interesting behavior if we are using long names when we do the writes.
>
> All the tables are defined using DDL using both long names and short. If
> we write to the tables using long names we see CPU shot straight up and
> running iDoctor reveals that each write seems to be making function calls
> to an internal system API that translates the long name to the short.
>
> It would make sense to me that it would do this once but for every records?
>
> To wirte 50,000 records using long names takes 8 seconds and 2 seconds
> using short names. We have a very big machine.
>
> Turn on Job Watcher and looked at CPU consumption. Huge spike straight up,
> straight across and down for long names. Doesn t even register for short
> names.
>
>
> Anybody else run into this?
>
> We are V7R2.
> --
> This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
> mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe,
> unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives at
> http://archive.midrange.com/rpg400-l.
>
>
>
> -----
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2016.0.7294 / Virus Database: 4489/11273 - Release Date: 12/28/15
>
>
>
> -----
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2016.0.7294 / Virus Database: 4489/11273 - Release Date: 12/28/15
>
>
> --
> This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
> mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.