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

[Andrew J. Schorr]

And please try the trivial changes I suggested to eliminate
the DOS TYPE command and pipeline:

gawk -f Emp_Attr.awk ParentChild.csv>Emp_Attr.csv
gawk -v f2=Emp_Attr.csv -f map_attr.awk ParentChild.csv>Map_Attr.csv

Regards,
Andy

On Tue, Jun 15, 2021 at 03:08:50PM +0000, Koleti, Haritha via Bug reports and 
all discussion about gawk. wrote:
> 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.

-- 
Andrew Schorr                      e-mail: aschorr@telemetry-investments.com
Telemetry Investments, L.L.C.      phone:  917-305-1748
152 W 36th St, #402                fax:    212-425-5550
New York, NY 10018-8765