Proformance issues with Power House on 9k...

[Deskin, Bob]

You say that the data sources are nearly identical. Are they both IMAGE
or Eloquence? If one is IMAGE and the other relational, then I'm not
surprised that there will be a difference. The degree of difference
depends on many factors including the power of the machine, the type of
access (simple access versus multiple linkage), the size of the
tables/datasets involved, the key/index structure, etc. Even if you use
an IMAGE emulator other than Eloquence, you will be using an underlying
relational database.

IMAGE is very fast and tuned for the HPe3000 which is also quite
efficient. It's no wonder that it's very popular.

Bob

-----Original Message-----
From: powerh-l-bounces+bob.deskin=cognos.com at lists.sowder.com
[mailto:powerh-l-bounces+bob.deskin=cognos.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


-- 
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l at lists.sowder.com
Subscribe: "subscribe" in message body to
powerh-l-request at lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request at lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber. 
  
       This message may contain privileged and/or confidential information.  If you have received this e-mail in error or are not the intended recipient, you may not use, copy, disseminate or distribute it; do not open any attachments, delete it immediately from your system and notify the sender promptly by e-mail that you have done so.  Thank you.