RE: ZPD File

The only impact is that you will not be able to use document regenereation; 
invoice re-print works regardless if the record is on the zpd or not (and our 
version puts out a record for every reprint).

We age all reprints everyday; pick release every 30 days; orders ever 90 days; 
invoices every 60 days. We wrote sql to do this. We had a couple other 
miscellaneous documents we also deleted.

We were at a couple million records; now down to about 500,000. We saw a 20% 
improvement in run times by reducing the records on zpd.

-----Original Message-----
From: rkonda@ig.com.br [mailto:rkonda@ig.com.br]
Sent: Monday, April 22, 2002 12:51 PM
To: bpcs-l@midrange.com
Subject: ZPD File


Hi Everybody,

Does Anybody know how I could clear the ZPD file ? or Could I clear this
file deleting inactive records only ? We´re 6004 version.
thanks in advance.
Renato

_________________________________________________________________________
Você podia estar baixando sua musica predileta, enquanto lia esse e-mail.
Não perca tempo, tenha acesso rápido a internet com o Super iG.
http://registro.ig.com.br/superig

_______________________________________________
This is the SSA's BPCS ERP System (BPCS-L) mailing list
To post a message email: BPCS-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/bpcs-l
or email: BPCS-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/bpcs-l.