Re: V6.0.04 Performance

You could also purge (or archive) some data.  I've seen examples of long
running jobs like AR agings drop to 23% of their original run time after
purging 40% of the physical data.  If you archive the data to another
library, it will be there when (inevitably) somebody just _has_ to have a
report which includes 5 year old data.

My company sells a product that will add the archiving feature to BPCS'
existing purge programs without programming, and you can define other
purge/archive jobs (for those files that don't have a purge routine) like
writing a query.  You can check it out at http://www.arctools.com .

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Purge and Archive your BPCS Data Without Programming with ARCTOOLS ™
DCSoftware, Inc.
(508) 435-8243
(508) 435-4498 (fax)
http://www.arctools.com
mailto:info@arctools.com
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++


-----Original Message-----
From: Doug Schneider <dschneider@gssolutions.com>
To: 'BPCS-L@midrange.com' <BPCS-L@midrange.com>
Date: Wednesday, June 09, 1999 7:08 PM
Subject: RE: V6.0.04 Performance


>maybe a little DB tuning is in order.  Take a look at the DB Essentials
>package from Centerfield Techology (www.centerfieldtechnology.com).  We
>used this at the Rochester Benchmark Center for a customer of ours, and
>improved performance tremendously.
>
>Douglas Schneider
>Systems Engineer
>G/S Solutions
>616-559-5518
>
>-----Original Message-----
>From: kromphardt@nexgensoftware.com [SMTP:kromphardt@nexgensoftware.com]
>Sent: Wednesday, June 09, 1999 3:07 PM
>To: BPCS-L@midrange.com
>Subject: Re: V6.0.04 Performance
>
>
>
>A hardware upgrade is likely where you're headed.
>
>
>
>
>
>
>David Davidson <davidavid30@hotmail.com> on 06/09/99 09:18:12 AM
>
>Please respond to BPCS-L@midrange.com
>
>To:   BPCS-L@midrange.com
>cc:    (bcc: Kelly Kromphardt/Nexgen)
>
>Subject:  V6.0.04 Performance
>
>
>
>
>I'm looking to improve performance in a variety of BPCS programs like
>ACR500, BOM500, 600, JIT500, PUR500, SFC600, CST500, 600, 900.  Besides the
>obvious removing SQL statements with native code what else can I look for?
>
>
>_______________________________________________________________


+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---