Re: Performance & SQL coding

[Ata510@xxxxxxx]

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