Two more scripts that are used in the below script.
Emp_att.awk - I am not sending this as it is working fast.
while( (getline<f2) > 0)
From: Koleti, Haritha
Sent: Tuesday, June 15, 2021 7:49 AM
To: 'Eli Zaretskii'<firstname.lastname@example.org>;email@example.com
Ricardo<Ricardo_D.Pereira@pseg.com>; Pirane, Marco<Marco.Pirane@pseg.com>
Subject: RE: [EXTERNAL] Re: Performance issues using GAWK 3.1.6 ->from Win 2008
to Win 2016
Good Morning Eli,
This is pretty straight forward script that is trying to Map the data between
two files. I am waiting on permission from our security team , so my
team(Ricardo,Marco) can send you the details.
But here is the script .
TYPE ParentChild.csv|gawk -f Emp_Attr.awk>Emp_Attr.csv ----> this is fast.
TYPE ParentChild.csv|gawk -v f2=Emp_Attr.csv -f map_attr.awk>Map_Attr.csv ->
this is where it takes time.
complete script in old server win 2008(excel 2010) completes in 10 mins. now on
new server 2016(excel 2016) takes 90 minutes.
There is NO change in the volume of data in 2 files .
From: Eli Zaretskii<firstname.lastname@example.org>
Sent: Tuesday, June 15, 2021 7:30 AM
Subject: Re: [EXTERNAL] Re: Performance issues using GAWK 3.1.6 ->from Win 2008
to Win 2016
***CAUTION******CAUTION******CAUTION***This e-mail is from an EXTERNAL address.
The actual sender is (email@example.com) which may be different from the display
address in the From: field. Be cautious of clicking on links or opening
attachments. Suspicious? Report it via the Report Phishing button. On mobile
phones, forward message to Cyber Security.
Date: Tue, 15 Jun 2021 01:51:06 -0600
Wolfgang Laun<firstname.lastname@example.org> wrote:
The durations 10 min and 90 min suggest to me that a lot of i/o is
going on. I have experienced performance changes of a similar order
of magnitude due to changes in the default i/o buffer size.
This is an interesting idea. Eli, what if you supply a binary built
with the following patch?
How does this theory explain the difference between the two Windows versions? They both
use the same value of the "optimal" buffer size.
I'd rather see in the script how much I/O it really does, and take it from
there. Suppose that it turns out the script invokes other programs a lot, or
does a lot of computations: then the investigation should go in some other
The information contained in this e-mail, including any attachment(s), is
intended solely for use by the named addressee(s). If you are not the intended
recipient, or a person designated as responsible for delivering such messages
to the intended recipient, you are not authorized to disclose, copy, distribute
or retain this message, in whole or in part, without written authorization from
PSEG. This e-mail may contain proprietary, confidential or privileged
information. If you have received this message in error, please notify the
sender immediately. This notice is included in all e-mail messages leaving
PSEG. Thank you for your cooperation.