|
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.
As an Amazon Associate we earn from qualifying purchases.
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.