RE: Question about reducing program start overhead

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Jerry Adams
Sent: Wednesday, November 12, 2008 12:57 PM
To: Midrange Systems Technical Discussion
Subject: RE: Question about reducing program start overhead

Plus, how much time could you possibly save by pre-opening
the file? These days I usually do USROPN's after figuring
out which table I want to open (not always a simple matter
here!), and I still get sub-second response times; that is,
the program may have to switch between files on every Enter key.

OPNDBF *may* have saved something on the B10, even an F35, but today?

Rob's right: program/application design is the key. Similar
to his analogy, I took a process that was taking 3-4 hours to
run; re-designed and re-programmed it - takes about 5 minutes now.

Jerry C. Adams
IBM System i Programmer/Analyst

Please pardon a very ignorant question. On our current system (looking
at an i to replace our z, maybe), we have a product called Strobe. It
can tell us where bottlenecks are in a program (without recompilation)
by doing "sampling" (i.e. a measurement is taken "n" times a second
while a program runs). This can show us CPU and I/O bottlenecks,
including bottleneck on database accesses. Does the "i" not have
anything similar?

--
John McKown
Systems Engineer IV
IT

Administrative Services Group

HealthMarkets(r)
Administrative Services Group
9151 Boulevard 26 * N. Richland Hills * TX 76010
(817) 255-3225 phone * (817)-961-6183 cell
john.mckown@xxxxxxxxxxxxxxxxx * www.HealthMarkets.com

Confidentiality Notice: This e-mail message, including any attachments,
is for the sole use of the intended recipient(s) and may contain
confidential or proprietary information. Any unauthorized review, use,
disclosure or distribution is prohibited. If you are not the intended
recipient, please contact the sender by reply e-mail and destroy all
copies of the original message.