Re: Performance & SQL coding

["Certz" <certz@xxxxxxxxxxxxxxxxxxxxxxxxx>]

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