Re: performance

Lisa:

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)
http://www.arctools.com
mailto:info@arctools.com
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++


-----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
up
>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
this
>month) in less than 3 minutes ... a big improvement!  Assuming I ran the
SQL
>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
+---