RE: [EXTERNAL] Re: Performance issues using GAWK 3.1.6 ->from Win 2008 to Win 2016

[Koleti, Haritha]

Hi Eli,

We have  100s of awk scripts.
195 K  records in Parent  file and employee has 5K.

Thanks
Haritha



[https://www.pseg.com/images/global/email/PSEG_emailsignature_PSEGw-tag_version2.png]<http://www.pseg.com>
[http://facebook.com/pseg]<http://www.facebook.com/pseg>        [Twitter] 
<http://www.twitter.com/psegdelivers>         [LinkedIn] 
<http://www.linkedin.com/company/pseg>       
[https://www.pseg.com/images/global/WP_LOGOgrey.png] <http://energizepseg.com/>


PSEGSC
-----Original Message-----
From: Eli Zaretskii <eliz@gnu.org>
Sent: Tuesday, June 15, 2021 11:07 AM
To: Koleti, Haritha <Haritha.Koleti@pseg.com>
Cc: mortoneccc@comcast.net; arnold@skeeve.com; wolfgang.laun@gmail.com; 
bug-gawk@gnu.org; Pereira, 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

***CAUTION******CAUTION******CAUTION***This e-mail is from an EXTERNAL address. 
 The actual sender is  (eliz@gnu.org) 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.

> From: "Koleti, Haritha" <Haritha.Koleti@pseg.com>
> CC: "mortoneccc@comcast.net" <mortoneccc@comcast.net>,
>         "arnold@skeeve.com"
> <arnold@skeeve.com>,
>         "wolfgang.laun@gmail.com" <wolfgang.laun@gmail.com>,
>         "bug-gawk@gnu.org" <bug-gawk@gnu.org>,
>         "Pereira, Ricardo"
> <Ricardo_D.Pereira@pseg.com>,
>         "Pirane, Marco" <Marco.Pirane@pseg.com>
> Date: Tue, 15 Jun 2021 14:58:37 +0000
>
> Hi Eli, As a first step in this triage, we checked the capacity of the
> servers and gave more capacity than 2008 servers, Even than no change in the 
> performance.

I suggest first to try the improvements in the script that were suggested here 
by Ed Morton.  Those improvements might make the difference a non-issue, if the 
running time goes down to seconds instead of minutes.

And I'd still like to know how many lines are in the ParentChild.csv file and 
in the Emp_Attr.csv file.

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.