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

[Andrew J. Schorr]

Hi,

I'm not sure that I understand your message. Are you saying that you are
getting different results from:

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

versus:

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

???

Is the difference in Emp_Attr.csv or Map_Attr.csv or both?
Or am I confused about what you are indicating? These commands
should be equivalent, and the latter versions should be faster,
I would think. If you additionally use Ed's modified version
of map_attr.awk, you should get top speed.

Regards,
Andy

On Tue, Jun 15, 2021 at 04:58:53PM +0000, Koleti, Haritha via Bug reports and 
all discussion about gawk. wrote:
> it runs faster but the final file is not as expected it is 192KB where 
> original file should have been 16230KB.
> 
> we are not getting right output that we require.
> 
> 
> 
> [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:33 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: "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 15:13:14 +0000
> >
> > This worked like a charm <1 minute.  But we have  100s of scripts .   if 
> > would really help if we can find a root
> > cause why this 10 minutes versus 90 minutes.
> 
> Try what Andrew suggested: eliminate the TYPE command and the pipe from the 
> batch file.  Does that speed up the time, and if so, by how much?
> 
> 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.