Billy,
We have an archiving routine. Each week, we copy ITH records over 2 years old to an archive file (ITH_ARCH) then remove them from ITH
ITH currently has 2. 5 million records, ITH_ARCH has 12.3 million records
Obviously it doesn't lessen the total disk taken up by ITH and ITH_ARCH records, but it speeds up BPCS processes like inquiries as they have less ITH records to scroll through.
We then created an in-house ITH inquiry program which looks at both ITH and ITH_ARCH
Tom Molyneux | Deputy MIS Manager
NOV Completion & Production Solutions
Greengate, Middleton, Manchester M24 1SA
Direct +44 161 214 2142
Mobile 0783 443 2791
Tom.Molyneux@xxxxxxx | www.nov.com
-----Original Message-----
From: BPCS-L [mailto:bpcs-l-bounces@xxxxxxxxxxxx] On Behalf Of Billy Waters
Sent: 22 February 2016 12:44
To: bpcs-l@xxxxxxxxxxxx
Subject: [EXTERNAL] [BPCS-L] ITH Size
Currently ITH 9 million records. Considering a process change that could greatly increase the daily ITH record created. Boss is concerned about the size of ITH and performance considerations. If you can please respond with your ITH size and any other information you feel would be of use. We cannot purge ITH at month end due to an internal reporting process. We are working on another new process that will allow purging of ITH at month end.
--
This is the BPCS ERP System (BPCS-L) mailing list To post a message email: BPCS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
https://urldefense.proofpoint.com/v2/url?u=http-3A__lists.midrange.com_mailman_listinfo_bpcs-2Dl&d=CwICAg&c=oTZJxWjXA97U5efbDJZGEg&r=iwlCIJOzH2dLA7sg-EkdbJ3IFfAoViMu6XNrO_4k9GM&m=SRXdY9RhkUuSCkdnrW5wWa_QL9CHeuhEbqlDQOGvrQU&s=d929F4Lo5fvKfzp65Jup1nWsYZYog4aNYHabuYi_pus&e=
or email: BPCS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://urldefense.proofpoint.com/v2/url?u=http-3A__archive.midrange.com_bpcs-2Dl&d=CwICAg&c=oTZJxWjXA97U5efbDJZGEg&r=iwlCIJOzH2dLA7sg-EkdbJ3IFfAoViMu6XNrO_4k9GM&m=SRXdY9RhkUuSCkdnrW5wWa_QL9CHeuhEbqlDQOGvrQU&s=KnrscQVuhewV89z38tDeDCb0pOGXe0a8OmtDRt0vS_8&e= .
As an Amazon Associate we earn from qualifying purchases.