One factor affecting HP3000 Ksam performance is inserting, updating and
deleting records where a lot of the records have the same key value. I
once improved a program's performance by over 90% simply by eliminating
duplicate keys.
I've not tested how Acucobol performs in this respect.
I assume you were using NM Ksam on the HP3000 using HP Cobol and the native
mode intrinsics (or just the standard cobol verbs) and Acucobol's own cobol
and vision files on Unix.
With my migration hat on, I'm pleased that you're getting better
performance on the Unix platform.
However, are you saying that the same test application only takes 1.5 hours
on the customer's MPE box ?
-----Original Message-----
From: HP-3000 Systems Discussion [mailto:[log in to unmask]] On Behalf
Of Peter Smithson
Sent: 23 September 2004 11:33
To: [log in to unmask]
Subject: [HP3000-L] Comparing speed of KSAM app on MPE vs HPUX
Hi,
I've been doing some searching on the internet and on usenet but I've not
found anyone comparing the speed of an application that does a lot of KSAM
work running on MPE vs HPUX.
I've been given a benchmark which does some KSAM testing. I know it's not
ideal - it's not multi user and it's heavily CPU bound as it just re-reads
two index files repeatedly. So it's of limited use but not of no use as a
comparision. It uses a mixture of searching, reading, re- writing and just
writing.
I'd be interested in comments, especially on how to speed it up on MPE as
the customer says it takes 1.5 hours on their MPE system. Maybe our MPE
system is a bit old.
No other users were on the machines but an incremental backup did kick off
on the hpux machine. The files were stored using the ACUCOBOL indexing
system on HPUX.
HPUX 11 running on a 160Mhz PA-RISC CPU using ACUCOBOL 6.0 takes 8.3 hours.
MPE 7 on a twin 180Mhz PA-RISC CPU using KSAMXL files takes 18.3 hours.
I know the 2nd processor on the MPE machine is of little use in this test so
I consider them roughly equal in processing power although the MPE system
has a slight speed advantage and I think it has a bigger instruction cache.
The intention of the test is to compare two Oracle systems (i.e. using
Oracle to store the KSAM files) on HPUX but I thought I'd try out some other
testing first. It'll be interesting to see how much slower it is using
Oracle.
Cheers
Peter
--
http://www.beluga.freeserve.co.uk
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________
The contents of this email are confidential to the intended recipient
and may not be disclosed. Although it is believed that this email and
any attachments are virus free, it is the responsibility of the recipient to confirm this.
Smith & Williamson Corporate Finance Limited - A member of M&A
International Inc. http://www.mergers.net Registered in England No.
4533970. Authorised and regulated by the Financial Services Authority
Smith & Williamson Investment Management Limited, Registered No. 976145. Authorised and regulated by the Financial Services Authority.
Smith & Williamson Pension Consultancy Limited - Independent
Intermediary. Registered No. 3133226. Authorised and regulated by the
Financial Services Authority.
Smith & Williamson Fund Administration Limited, Registered No. 1934644. Authorised and regulated by the Financial Services Authority.
Smith & Williamson Limited - A member of Nexia International.
Registered in England No. 4534022. Regulated by the Institute of
Chartered Accountants in England & Wales for a range of investment
business activities.
Registered Office: No 1 Riding House Street, London W1A 3AS
Telephone: 020 7637 5377 http://www.smith.williamson.co.uk
Nexia Audit Limited - A member of Nexia International. Registered in
England No. 4469576. Registered to carry on audit work and regulated by the Institute of Chartered Accountants in England & Wales for a range of investment business activities.
Registered Office: No 1 Riding House Street, London W1A 3AS
Telephone: 020 7637 5377 http://www.nexiaaudit.co.uk
NCL Investments Limited, Registered No. 1913794.
Member of the London Stock Exchange authorised and regulated by the Financial Services Authority.
Registered Office: Bartlett House, 9-12 Basinghall Street, London EC2V 5NS
Telephone: 020 7600 2801
______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|
