Re: performance

Lisa,

You may want to consider the modification we made to INV970.  We took out the
logic that removed and re-sequenced the ITH records.  We do this now only on
demand (not even twice a year).

Bill

Lisa Abney wrote:
> 
> 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
> 
> -----Original Message-----
> From: Lacelle, Marc <LACELLE@rcmint.ca>
> To: 'BPCS-L@midrange.com' <BPCS-L@midrange.com>
> Date: Monday, June 21, 1999 2:07 PM
> Subject: RE: performance
> 
> >Hi Roger.
> >
> > I am aware of the INV970D and all of the other Reorg options
> >provided by BPCS. Beleive me,  run the SQL statements I mentioned below
> >after running the INV970D. You will be surprised.
> >
> >> ----------
> >> From: Wolf, Roger[SMTP:Roger.Wolf@garmin.com]
> >> Reply To: BPCS-L@midrange.com
> >> Sent: Monday, June 21, 1999 12:15 PM
> >> To: 'BPCS-L@midrange.com'
> >> Subject: RE: performance
> >>
> >> Forgive me.
> >>
> >> But, In BPCS405CD INV970 does the same thing.  We did one modification to
> >> it to test the individual fields for zero instead of in total.  The users
> >> wanted to see Opening Balance, receipts, adjustments and Issue.
> >>
> >> INV970 is on the system file clean up menu.
> >>
> >> Would hope there would be a similar thing in your release.
> >>
> >> Best Regards,
> >> Roger Wolf
> >>
> >> -----Original Message-----
> >> From:   Lacelle, Marc [SMTP:LACELLE@rcmint.ca]
> >> Sent:   Monday, June 21, 1999 7:51 AM
> >> To:     'BPCS-L@midrange.com'
> >> Subject:        RE: performance
> >>
> >> Hi Ho.
> >>
> >>         This one can be tried by anyone who finds that their
> >> response times
> >> are slow. This will also improve your reporting times (INV230,INV260
> >> .....)
> >>
> >> 1.      No users can be on when running these statements (very
> >> important)
> >> 2.      Do this right after month end
> >> 2.      Backup the following files (ILI, IWI)
> >> 3.      RUN THESE SQL STATEMENTS
> >> 4.      delete from ???/ili where (lopb + lrct + ladju - lissu) = 0
> >> 5.      The ??? is the name of your data library
> >> 6.      delete from ???/iwi where (wopb + wrct + wadj - wiss) = 0
> >> 7.      The ??? is the name of your data library
> >>
> >>         These statements can actually take a few minutes. It all
> >> depends on
> >> the number of records you have in these data files.
> >>
> >>         When I first wrote and tested these statements I was quite
> >> surprised
> >> to find that our ILI file went from 365,000 to 100,000 records (this took
> >> about 10 minutes to execute).
> >>
> >>         Enjoy
> >>
> >>         Marc Lacelle
> >>         Programmer Analyst
> >>         Royal Canadian Mint
> >>
> >>
> >>
> >> > ----------
> >> > From:
> >> jos.kramer@kaochemicals.de[SMTP:jos.kramer@kaochemicals.de]
> >> > Reply To:     BPCS-L@midrange.com
> >> > Sent:         Monday, June 21, 1999 5:16 AM
> >> > To:   BPCS-L@midrange.com
> >> > Subject:      performance
> >> >
> >> > Dear Members,
> >> >
> >> > I would like to know if someone has tips on how to improve performance
> >> on
> >> > the
> >> > following programms in BPCS 6.1:
> >> >
> >> > INV300, ORD550 (Action 12 allocations), ORD720 (order allocations).
> >> > Generally all the programm that use allocations are extremely slow.
> >> >
> >> > Thanks in advance,
> >> >
> >> > jos.kramer@kaochemicals.de
> >> >
> >>
> >>
> >+---
> >| 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 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 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
+---