|
I thought when running month end (INV903D), the cycle count data file was reset. (ICY)???? > ---------- > From: klvanhorn@lozier.com[SMTP:klvanhorn@lozier.com] > Reply To: BPCS-L@midrange.com > Sent: Tuesday, June 22, 1999 11:43 AM > To: BPCS-L@midrange.com > Subject: RE: performance > > What impact does this have on open cycle counts? > > Kent Van Horn > Lozier Corp > > ---------- > From: Lisa Abney[SMTP:abney@iquest.net] > Sent: Monday, June 21, 1999 3:34 PM > To: BPCS-L@midrange.com > 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 > > -----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 > +--- > +--- | 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 +---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.