What naming conventions are you using? SQL Naming or System Naming conventions?
When using System Naming Conventions in composition with long SQL Names, those SQL names have to be converted into the short system names, which may cause a performance decrease.
When using SQL Naming Conventions the long SQL Names can be used directly.
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
"Shoot for the moon, even if you miss, you'll land among the stars." (Les Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them and keeping them!"
-----Ursprüngliche Nachricht-----
Von: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] Im Auftrag von Alan Campin
Gesendet: Monday, 28.12 2015 17:42
An: RPG programming on the IBM i / System i
Betreff: 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.
midrange.com
