RE: Improving System/21 Performance

I would also be interested in this.

Diana Larsson
IT Applications Development Manager
Arden Companies
18000 West 9 Mile Rd
Suite 700
Southfield, MI 48075
Phone: 1.248.368.6624
Fax: 1.305.832.0589
dlarsson@xxxxxxxxxxxxxxxxxx
 

-----Original Message-----
From: system21-bounces@xxxxxxxxxxxx [mailto:system21-bounces@xxxxxxxxxxxx]
On Behalf Of Dilhani Rajapaksha (CW)
Sent: Monday, August 29, 2005 10:31 PM
To: System 21 Users
Subject: RE: [SYSTEM21] Improving System/21 Performance

I am interested on it.

Thanks


-----Original Message-----
From: CMassoglia@xxxxxxxxxxxxx [mailto:CMassoglia@xxxxxxxxxxxxx] 
Sent: Monday, August 29, 2005 6:26 PM
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 INBOUND E-mail and document(s) has been scanned by an Antivirus Server.




                                                ARDEN
                                           A Global Company
  Celebrating over 40 years of making your life more comfortable!

This message may contain confidential and/or privileged information.  If you 
are not the adressee 
or authorized to receive this for the adressee, you must not use, copy, 
disclose, or take any action 
based on this message or any information herein.  If you have received this 
message in error, 
please advise the sender immediately by reply e-mail and delete this message.

This OUTBOUND E-mail and Document(s) has been scanned by an Antivirus Server.