• Subject: Re: performance
  • From: "David Shea" <dshea@xxxxxxxxxxxx>
  • Date: Tue, 22 Jun 1999 08:29:49 -0400


Is there any need archive those records?  Since you are using ARCTOOLS, you
could use it to archive the data if needed instead of just deleting it.

Purge and Archive your BPCS Data Without Programming with ARCTOOLS 
DCSoftware, Inc.
(508) 435-8243
(508) 435-4498 (fax)

-----Original Message-----
From: Lisa Abney <abney@iquest.net>
To: BPCS-L@midrange.com <BPCS-L@midrange.com>
Date: Monday, June 21, 1999 8:44 PM
Subject: Re: performance

>Marc/Roger ...
>We are on 4.0.5, and run INV970 as part of our normal month end.  However,
>due to the length of time it takes, we tend to skip it if the month end
>doesn't fall on a weekend (as we're really pressed to get the system back
>to the users after our month end process).  The last time we did run, it
>took 4 hours on a dedicated system (and we have a pretty big box!).  Right
>now, the last time we ran it was Dec 31, and we have 917151 records in ILI
>with 0 balances, and only 35266 that are not 0!
>I just ran your SQL over a test copy of ILI, and was able to delete 897668
>records (I selected with all 0's in the fields, in case it had activity
>month) in less than 3 minutes ... a big improvement!  Assuming I ran the
>statement as part of my month end (after INV900), any reason you can think
>of I couldn't run this over ILI/IWI instead of running INV970?
>Lisa Abney

| 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

This thread ...

Return to Archive home page | Return to MIDRANGE.COM home page