Your Progress OpenEdge Database Expert

How Fast Will It Go? Progress OpenEdge Database Performance on HP-UX

Skip To Table

Other Extended Performance Data Tables

Performance Leaders
Unix Variants on Intel
Microsoft Windows on Intel
HP-UX Servers
IBM AIX Servers
SUN Solaris Servers
Ancient Configurations

Measuring Ideal Read Performance

Many real world performance problems are related to how fast records can be read from the database -- not how fast you can write them. After all the read:write ratio for most applications is hundreds to one -- read performance is far more likely to be an issue than write performance!

An interesting question, therefore, is "how many records can my machine read per second?" The ultimate answer depends on a great many factors such as the amount of memory, the capabilities of the disk subsystem, the number of CPUs, their speed, type and configuration and the "other" workload on the machine. Many of these factors are highly variable and difficult to predict or simulate.

It is, however, possible to determine what the upper limit for a given box is under ideal circumstances. The readprobe.p tool is designed to determine what this limit is. The probe loads the entire sports database into memory and deliberately does no IO (Remember these are ideal conditions. You'll never go this fast in real life but you should be able to come very close.)

The data is also useful for determining how well tuned your system is -- if you are achieving results that are close to these ideal numbers then you're out of tuning options. You need faster CPUs to go any faster. But if you are not getting results that are close to these numbers you have room to improve through other changes.

The following table summarizes results from running readprobe.p on a number of HP-UX systems with different characteristics:

Greenfield Technologies knowledge of business, applications, and infrastructure helps companies to develop and deploy applications which are built to last and designed to exceed user expectations.

-- Rob Lux
Enterprise Services Manager
Large Global IT Outsourcing Firm

With technology evolving at an increasingly challenging rate, it’s great to have a partner that you trust, and one that you can leverage to help your business take advantage of a constantly changing technology landscape. Greenfield Technologies has been there for us in the past, and will be THE partner we go to in the future when we need in-depth expertise.

-- Todd Lunsford
CIO
Quicken Loans

Greenfield Technologies in depth knowledge of the Progress database and our application made it possible to not only prepare our hardware, operating system and Progress software upgrade to a point that we felt very comfortable to go ahead with it, but also enabled us to execute it in less time than anticipated and resulted in a much larger performance improvement than we expected! Tom’s motto to prepare well and test twice beforehand paid off fully.

-- Gabriela Summerer-Herndon
Unix Admin, Progress DBA
Columbia National Inc.

We just watched! You deserve the credit! Thanks again!

-- Alex Hillman

Thank you for your extraordinary efforts during the past few days. All of us really appreciate it. Given our volume and customer service requirements, your support -- which extended far beyond the normal work day and schedule -- was invaluable.

-- Jenne Britell

Thank you again for going the "extra mile".

-- Ben Smith

Tom, you especially have gone beyond the call of duty in monitoring our system and getting issues regarding capacity etc resolved.

-- Matt White

Great program! Great features!.

-- Scott Cooper

Thank you for your work on the [...] rehosting project. Expediting the conversion of the Progress Database was critical to our success. The knowledge that you brought to the team about Progress tuning and database management helped not only with this effort but will improve our on-going management of the database. Thank you!

-- Anonymous CIO


ProJAX

ProJAX is an implementation of AJAX designed to get Progress developers, especially those working in legacy environments, up and running with a minimum of muss or fuss. ProJAX makes it simple to leverage your existing Progress 4GL programming skills to deliver rich and responsive web applications without annoying delays and timeouts for page refreshes.


Have a question?
Don't know where to look?

Contact Us!

Address: White Star Software
PO Box 3058
Nashua, NH 03061
Cell: +1 603 396 4886
E-mail: mailwss.com
wss.com

Other Great Progress Resources:

HP-UX ReadProbe Performance Table

CPU Type
# x Speed 		OS Progress -spin Single User Best Users Records/sec Chart Note
HP
rp7410 PA 8700
8 x 875 		HPUX 11i 9.1C 20,000 71,074 8 180,954 Missing 0100

1,000 "user" stress test

rp7410 PA 8700
8 x 875 		HPUX 11i 9.1C 50,000 71,011 8 172,658 Missing 0102

Large -spin (as suggested by TS)

rp7410 PA 8700
8 x 875 		HPUX 11i 9.1C 20,000 70,996 8 171,771 Missing 0101

Superdome
16 x 875 		HPUX 11i 9.1D05 10,000 70,639 49 156,065 Missing 0151


8 x 875 		HPUX 11i 9.1D0607 50,000 67,389 8 155,578 Missing 0220


8 x 875 		HPUX 11i 9.1D0607 50,000 67,541 8 154,580 Missing 0201


8 x 875 		HPUX 11i 9.1D0607 999,999 67,535 8 153,512 Missing 0208


8 x 875 		HPUX 11i 9.1D0607 50,000 67,303 8 153,362 Missing 0219


8 x 875 		HPUX 11i 9.1D0607 250,000 66,349 8 153,252 Missing 0203


8 x 875 		HPUX 11i 9.1D0607 750,000 66,388 8 152,974 Missing 0207


8 x 875 		HPUX 11i 9.1D0607 500,000 67,488 8 152,938 Missing 0204


8 x 875 		HPUX 11i 9.1D0607 25,000 67,353 8 150,875 Missing 0206


8 x 875 		HPUX 11i 9.1D0607 100,000 65,916 7 149,641 Missing 0202

rp8400
12 x 875 		HPUX 11i 9.1D05 10,000 70,574 12 148,703 Missing 0149

rp8400
12 x 875 		HPUX 11.11 9.1D 10,000 70,574 12 148,703 Missing 0136


8 x 875 		HPUX 11i 9.1D0607 10,000 65,528 8 147,889 Missing 0200


8 x 875 		HPUX 11i 9.1D0607 12,000 67,264 8 146,849 Missing 0205


8 x 875 		HPUX 11i 10.0B 100,000 62,607 8 140,569 Missing 0213


8 x 875 		HPUX 11i 10.0B 500,000 62,697 8 138,970 Missing 0215


8 x 875 		HPUX 11i 10.0B 50,000 62,644 8 138,507 Missing 0212


8 x 875 		HPUX 11i 10.0B 250,000 62,634 8 138,398 Missing 0214


8 x 875 		HPUX 11i 10.0B 750,000 62,718 8 136,035 Missing 0216


8 x 875 		HPUX 11i 10.0B 10,000 62,715 8 133,646 Missing 0210


8 x 875 		HPUX 11i 10.0B 12,000 62,659 8 132,284 Missing 0209


8 x 875 		HPUX 11i 10.0B 25,000 62,683 8 132,017 Missing 0211


8 x 875 		HPUX 11i 10.0B 50,000 62,743 8 131,681 Missing 0218

rp8400
4 x 875 		HPUX 11.11 9.1D 30,000 63,590 4 123,865 Missing 0183

-Mpte -B 10000 -napmax 5000 -semsets 10

rp8400
4 x 875 		HPUX 11.11 9.1D 10,000 63,685 4 123,739 Missing 0179

-Mpte -B 10000 -napmax 5000 -semsets 10

rp8400
4 x 875 		HPUX 11.11 9.1D 10,000 64,478 8 120,582 Missing 0178

-mux 0 -Mpte -B 10000 -napmax 5000 -semsets 10

rp8400
4 x 875 		HPUX 11.11 9.1D 30,000 64,527 4 119,965 Missing 0184

-mux 0 -Mpte -B 5000 -napmax 5000

rp8400
4 x 875 		HPUX 11.11 9.1D 10,000 64,547 8 109,104 Missing 0174

-mux 0 -Mpte -B 10000 -napmax 5000 -semsets 4

rp8400
4 x 875 		HPUX 11.11 9.1D 30,000 64,561 8 107,926 Missing 0169

-mux 0 -Mpte -B 10000 -napmax 5000

rp8400
4 x 875 		HPUX 11.11 9.1D 10,000 63,625 4 107,909 Missing 0168

-Mpte -B 5000 -napmax 5000

rp8400
4 x 875 		HPUX 11.11 9.1D 20,000 64,582 4 107,243 Missing 0170

-mux 0 -Mpte -B 5000

rp8400
4 x 875 		HPUX 11.11 9.1D 10,000 64,543 4 106,703 Missing 0167

-mux 0 -Mpte -B 5000 -napmax 5000

rp5470
4 x 750 		HPUX 11i 8.3E05 10,000 75,424 3 102,750 Missing 0194

N Class
4 x 540 		HPUX 11 9.1C 10,000 44,494 15 98,021 Missing 0045

rp8400
6 x 750 		HPUX 11i 8.3E05 10,000 76,892 3 81,124 Missing 0193

rp8400
6 x 750 		HPUX 11i 8.3E05 10,000 77,199 4 79,513 Missing 0192

L Class
4 x 440 		HPUX 11.11 9.1D 10,000 32,366 4 78,904 Missing 0134

rp2405
2 x 650 		HPUX 11.11 9.1D 10,000 51,005 2 76,769 Missing 0137

rp2405
2 x 650 		HPUX 11i 9.1D05 10,000 51,005 2 76,769 Missing 0150

V2600
24 x 550 		HPUX 11 9.1C 10,000 44,145 6 65,524 Missing 0043

V2200 PA 8200
12 x 200 		HPUX 11 9.1C 20,000 5,693 13 62,821 Missing 0104


8 x 875 		HPUX 11i 10.0B 999,999 62,430 1 62,430 Missing 0217

K580
4 x 240 		HPUX 11i 8.3E05 10,000 22,083 8 62,388 Missing 0191

L Class
2 x 400 		HPUX 11 9.1C 10,000 43,534 3 57,791 Missing 0044

K460
4 x 180 		HPUX 11 9.1C 10,000 8,515 4 29,801 Missing 0069

K420
4 x 120 		HPUX 11.0 8.3B22 10,000 8,913 14 22,998 Missing 0185

K410
3 x 120 		HPUX 11.0 8.3B22 10,000 7,778 3 17,187 Missing 0187

T600 PA 7100
8 x 90 		HPUX 11 9.1C 10,000 3,857 8 16,836 Missing 0105

D370
2 x 160 		HPUX 11 9.1C 10,000 8,539 8 14,989 Missing 0068

K420
4 x 120 		HPUX 11.0 8.3B22 10,000 7,136 18 13,771 Missing 0186

D360
2 x 120 		HPUX 11 9.1C 10,000 6,825 2 11,700 Missing 0067

D320
1 x 0 		HPUX 11 9.1C 1 4,865 1 4,865 Missing 0107

Unknown clock speed (why do they make it so hard to find?)

What Readprobe is NOT

Readprobe doesn't tell you everything about a machine. It shows one very specific metric -- how many records can be read under ideal circumstances. This happens to be a very useful thing to know. But it is not everything that you need to know nor can you make an informed decision based solely on that result. If you would like help applying these lessons to your situation contact Greenfield Technologies today to schedule an appointment!