× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. BPCS-L
  3. June 1999

RE: performance

  • Subject: RE: performance
  • From: "Lacelle, Marc" <LACELLE@xxxxxxxxx>
  • Date: Wed, 23 Jun 1999 10:06:30 -0400
 
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 thread ...
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.