How Fast Will It Go? Progress OpenEdge Database Performance -- Ancient History
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 an archaeological dig in ancient, dusty attics running readprobe.p on the oldest relics that could be found! Be thankful that these are not your production machines!
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:
