× 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.


  • Subject: RE: performance
  • From: "Lacelle, Marc" <LACELLE@xxxxxxxxx>
  • Date: Mon, 21 Jun 1999 08:50:40 -0400

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
+---


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.