Performance issues with Power House on 9k...

[Pickering, John (NORBORD)]

Mike

>From the statistics at the end of your run it looks like the same value of
ACCT_ID_NBR exists in more than one of the tables to which you are linking.
And it also appears that the whole purpose of this Qtp is to get a value for
ACCT_NAME based on the value of the BILL_TO flag.

So, how about if you split the subfile up into 3 subfiles based on the
BILL_TO flag. Something like the following ...

Request split_by_bill_to
Access *$CTEMPDATA/mer0010a alias SF
Subfile $CTEMPDATA/mer0010I if BILL_TO of SF = "I " include SF
Subfile $CTEMPDATA/mer0010D if BILL_TO of SF = "D " include SF
Subfile $CTEMPDATA/mer0010G if BILL_TO of SF = "G" include SF

Then create 3 new requests, one for each of the subfiles created in the
first request. Each of these requests will read one of the subfiles and link
to the appropriate table to get the description. The first will build a new
subfile with the original plus the defined item (or better, a Global Temp)
ACCT_NAME. The second and third requests will do the same and append to the
same subfile.

This should cut down on the size of the record complex and the unnecessary
data retrieval.

And you are starting to see why we HP 3000 fans are so passionate [and so
ticked at HP]. I hope the 9000 has at least double the horsepower of the
3000 it is replacing. And if it has Orakill then double won't be nearly
enough.

Regards,
JWP

-----Original Message-----
From: powerh-l-bounces+ken.langendock=rogers.com at lists.sowder.com
[mailto:powerh-l-bounces+ken.langendock=rogers.com at lists.sowder.com] On
Behalf Of Michael Matteini
Sent: September 2, 2005 11:31 AM
To: powerh-l at lists.sowder.com
Subject: Proformance issues with Power House on 9k...


Is anyone aware of any performance issues migrating QTP code from HP3K
to HPUX?  The code-block below took only 20 minutes on the HP3K, but ran
for 9 HOURS under Unix!  (Data sources on both environments are nearly
identical.)  Something must be amiss.
 
Thanks in Advance,
Mike Matteini
Trinity Info Services
 

RUN $CQTP/mer0012
SET LOCK FILE UPD
SET INP 4000000
REQUEST MER0012A
ACC *$CTEMPDATA/mer0010a ALIAS SF &
  LINK ACCT_ID_NBR TO CONTRACT_NBR OF CONTRACT ALIAS CH OPT &
  LINK ACCT_ID_NBR TO DIVISION_NBR OF DIVISION ALIAS DI OPT &
  LINK ACCT_ID_NBR TO GROUP_NBR    OF GROUP_M  ALIAS GR OPT
 
SEL CH IF ACCT_ID_NBR OF SF=CONTRACT_NBR OF CH AND BILL_TO OF SF='I '
SEL DI IF ACCT_ID_NBR OF SF=DIVISION_NBR OF DI AND BILL_TO OF SF='D '
SEL GR IF ACCT_ID_NBR OF SF=GROUP_NBR    OF GR AND BILL_TO OF SF='G '
 
DEF ACCT_NAME CHAR*20 = &
       NAME_X OF DI IF REC DI EXISTS &
  ELSE NAME_X OF GR IF REC GR EXISTS &
  ELSE PACK(LASTNAME OF CH + ', ' + FIRSTNAME OF CH) IF REC CH EXISTS
&
  ELSE 'Acct name not found.'
SUB $CTEMPDATA/mer0010m KEEP INCLUDE SF, ACCT_NAME
...
 

09/01/2005  11:10    AMISYS, LLC                                     
PAGE   1
 
Run:     mer0012
Request: MER0012A
 
Executing request MER0012A ...
 
Records read:
  SF                                 672,488
  CH                                 141,392
  DI                                 514,457
  GR                                 523,915
 
Transactions processed:              672,488
 
Records processed:                     Added    Updated  Unchanged   
Deleted
  MER0010M                           672,488          0          0     
    0
 

09/01/2005  20:23    AMISYS, LLC                                     
PAGE   1
...

Michael Matteini
Trinity Information Systems
Systems Analyst
Phone: (248) 489-6872