Our ZPD file has only 1999 records from January through Now, excluding all
Pick Tickets and Shipping Documents.
We  purge Pick Tickets and Shipping Documents daily. The system just gets
to slow if I don't.  Also I have to purge old ECH & ECL records because the
client version of order entry runs slow if I do not.

Sincerely,

Chris Ertz






Ata510@aol.com on 07/20/99 04:10:28 PM

Please respond to BPCS-L@midrange.com

To:   BPCS-L@midrange.com
cc:
Subject:  Re: Performance & SQL coding

In a message dated 7/20/99 8:01:50 PM Central Daylight Time,
certz@americanmetalproducts.com writes:
>
>  There is a big difference from 405 CD and a 6.x version of BPCS.
>  Take invoice reprints using 405 CD - not an issue - immediate output.
>  Take invoice reprints using 6.X could run for hours - per invoice - even
>  with the logicals built in order to help performance - even on a 620
>  machine.
Have you tried checking the size of your ZPD file? You should only keep
records you would ever potentially re-print - you may want to purge file
occasionally by date or by form type/date range.
+---
| 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 thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 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].