Proformance issues with Power House on 9k...

Tue Sep 6 11:22:24 CDT 2005

I just got back from holidays to find a bunch of discussions that all skirt
around the issue of performance problems when going to a relational data
model.  Someone (I don't recall who) mentioned the need for a good DBA
(database administrator) to help with tuning.  

There's only so much that Powerhouse can do: with Oracle or DB2 or even
C-ISAM (which is NOT a relational database) much of the processing is
undertaken by the RDMBS and much of the tuning has to be done with indexes,
or code modifications to take advantage of the indexes.

Fortunately, such expertise can be out-sourced, which is what we have done
since our DBA retired.  

When switching platforms you WILL find instances where what worked on the
HP3000 simply does NOT translate well to another platform / file structure.
I remember moving from HP3000/Image to HP9000 / C-ISAM and finding that a
delete became spectacularly inefficient.  

So, if you're going relational, you MUST know what indexes you have and are
using and if you don't have the expertise in-house, HIRE IT!  You'll save
money in the long run.

Guy L. Werry
Senior Systems Analyst
Hudson Bay Mining & Smelting Co., Limited. 

-----Original Message-----
From: Deskin, Bob [mailto:Bob.Deskin at cognos.com]
Sent: Tuesday, September 06, 2005 9:56 AM
To: Michael Matteini; powerh-l at lists.sowder.com
Subject: RE: Proformance issues with Power House on 9k...

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 &lt;password&gt;" 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. 

-- 
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l at lists.sowder.com
Subscribe: "subscribe" in message body to powerh-l-request at lists.sowder.com
Unsubscribe: "unsubscribe &lt;password&gt;" 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.