RE: [SPAM] - Improving System/21 Performance - Email found in subject

I would be very interested.

Mark Lowry
www.indespension.co.uk
www.parnells.ie

-----Original Message-----
From: CMassoglia@xxxxxxxxxxxxx [mailto:CMassoglia@xxxxxxxxxxxxx] 
Sent: 29 August 2005 13:26
To: System 21 Users
Subject: [SPAM] - [SYSTEM21] Improving System/21 Performance - Email found
in subject





If you have not analyzed access path creation in System/21 using STRDBMON,
your system probably runs far slower that it should.  We substantially
reduced our month end processing time without changing a single program.
Some on demand and daily reports that used to take minutes to run now take
seconds.  Using STRDBMON, we were able to identify temporary access paths
created by SQL, OPNQRYF, and Query/400 that either took forever to create
or were created frequently.  All we had to do was create logical paths
using the suggested key structure.

If anyone is interested, I have a short 9 page PowerPoint presentation that
describes the technique in more detail.

Thanks.

Charlie Massoglia
Chief Information Officer
cmassoglia@xxxxxxxxxxxxx
517-780-4336
Fax:  517-789-4503



_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list
To post a message email: SYSTEM21@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/system21.

This message is private and confidential and is intended only for the addressee.
If you have received this message in error please contact the sender 
Mark.Lowry@xxxxxxxxxxxxxxxxxx and delete the message from any computer.
Any views or opinions expressed within this message are solely those of the 
author and do not necessarily represent the views or opinions of Indespension 
Ltd.