Slow performance while doing "Run command" - ideas appreciated

[Steve Fatula]

This is a multi-part message in MIME format.
--------------8592B3D39132E48ADD76F88E
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

What I have tended to do is put all of the commands into a command file, and
execute the command file via the run command instead of each individual
command. Granted, the run command of the command file is not as quick as we
would like, but at least there is only one of them, and performance becomes
quite acceptable. All error checking, etc., can be done in the command file.

But, yes, the run command construct is VERY slow.

Hans-Ole Kaae wrote:

> Hi,
>
> This goes for PH 8.19 C3 on a HP 3000/987, MPE/iX 5.5 with PP5.
>
> While checking out some old programs, I found that a normal way
> of sorting in Quick in this particular system is as follows:
>
> 1) Purge a temporary file
> 2) Build a temporary file
> 3) Put the sort-statements in this temporary file
> 4) Purge the outfile file (temporary)
> 5) Build the output file (temporary)
> 5) Setting up a file-equation for the output file
> 6) Invoking sort - via CI.PUB.SYS
> 7) A little clean-up and housekeeping...
>
> All using the RUN COMMAND construct.
>
> This runs very, very slow, indeed.
>
> Does anyone have a good idea how to improve performance
> radically on this?
>
> I guess a few of the statements could be avioded, tuned etc. but
> what I go for is really cutting down the many seconds, the program
> is working and the user is waiting.
>
> Just tried to put all the handling in a separate 3GL-program.
> Runs perfectly fast - but as soon as PowerHouse is calling the
> program via RUN COMMAND, the process again slows dramatically.
>
> I guess the real culprit is the RUN COMMAND construct - but it's
> not easy to avoid in this context.
>
> Of course we could re-design all the screens using Quiz and sorted
> subfiles; but I suppose it should be possible to implement all this
> in Qdesign using sort-intrinsics and a DO EXTERNAL construct, maybe?
>
> All suggestions are most welcome, either thru The List or mailed
> directly.
>
> TIA!
>
> With kind regards,
>
> /Hans
>
> Hans-Ole Kaae, IT-Consultant, ScanConsult·IT-Partners ApS
> E-mail: hok@scanconsult.dk
>
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
> Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
> powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
> This list is closed, thus to post to the list, you must be a subscriber.

--------------8592B3D39132E48ADD76F88E
Content-Type: text/x-vcard; charset=us-ascii;
 name="compconsultant.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Steve Fatula
Content-Disposition: attachment;
 filename="compconsultant.vcf"

begin:vcard 
n:Fatula;Steve 
tel;pager:972-529-7668
tel;cell:972-529-7668
tel;fax:972-837-4559
tel;home:972-837-4558
tel;work:972-529-7668
x-mozilla-html:TRUE
org:Fatula Consulting
adr:;;32 Country Ridge Rd.;Melissa;TX;75454;USA
version:2.1
email;internet:compconsultant@yahoo.com
note;quoted-printable:MANMAN, HP3000, Ingres, Fortran, Cobol, Powerhouse,=0D=0AVB,Uniface, Image, Suprtool, SFD, Systems Admin and more
fn:Steve J Fatula
end:vcard

--------------8592B3D39132E48ADD76F88E--

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.