Proformance issues with Power House on 9k...

[Joe Boyle]

also I think that 'lock record' does no checksumming, whereas 'lock file'
does creating overhead - if you are the only process writing to the subfile
checksumming wouldn't be required.

You could also open your input files using 'set file xyz open read
exclusive' which I seem to recall from the back of my (VMS/RMS) memory,
makes record locking redundant, thereby saving time.

Regards, Joe.


-----Original Message-----
From: powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com
[mailto:powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com] On Behalf Of
Joe Boyle
Sent: 02 September 2005 17:38
To: 'Michael Matteini'; powerh-l at lists.sowder.com
Subject: RE: Proformance issues with Power House on 9k...

you could try SET LOCK record UPD rather than SET LOCK FILE UPD, it doesn't
seem that you are likely to have any conflicting activity on the output
file.

Regards, Joe.


-----Original Message-----
From: powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com
[mailto:powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com] On Behalf Of
Michael Matteini
Sent: 02 September 2005 16:31
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.

-- 
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.