Re: Improving System/21 Performance

Charlie,

I would like you Power point presentation also.

Thanks

Barbara Byrne
Greatex Mills
(514)388-1700

----- Original Message -----
From: <John.Mcpherson@xxxxxxxxxxxxxxxx>
To: "System 21 Users" <system21@xxxxxxxxxxxx>
Sent: Monday, August 29, 2005 9:02 AM
Subject: RE: [SYSTEM21] Improving System/21 Performance


> Me too.
>
> Cheers,
> John
>
>
>
>
>
>              "Chris Payne"
>              <CPayne@TheCrownG
>              rp.com>                                                    To
>              Sent by:                  "System 21 Users"
>              system21-bounces@         <system21@xxxxxxxxxxxx>
>              midrange.com                                               cc
>
>                                                                    Subject
>              29/08/2005 13:52          RE: [SYSTEM21]   Improving
>                                        System/21 Performance
>
>              Please respond to
>               System 21 Users
>              <system21@midrang
>                   e.com>
>
>
>
>
>
>
> I would be very interested in seeing that.
>
> Chris
>
> -----Original Message-----
> From: system21-bounces@xxxxxxxxxxxx
> [mailto:system21-bounces@xxxxxxxxxxxx] On Behalf Of
> CMassoglia@xxxxxxxxxxxxx
> Sent: Monday, August 29, 2005 8:26 AM
> To: System 21 Users
> Subject: [SYSTEM21] Improving System/21 Performance
>
>
>
>
>
> 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 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 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.
>
>