Proformance issues with Power House on 9k...

[Michael Matteini]

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