|
Hello Otto,Steve is right, some SQL indexes will help. So will the BPCS Archiving! Dean has already mentioned this - it is sold as 'Locksmith' in the US, but you can get a demo copy from us in Europe, (and we directors of Small Blue worked on BPCS with several companies in the Czech Republic during the 90s - Ferona for example.) What the BPCS Archiving does is to remove the older records to a separate database where they can still be queried if required, but where they do not impact transaction times. And not just for the RAR, but for all areas of BPCS, and many files that impact many transaction programs, such as CMF and ZPD etc. A combination of Archiving and database tuning (creating indexes etc) has never failed yet to dramatically speed up the run times of month-end programs(for example 3 hours plus down to 20 minutes - Novartis Dublin), nor to have users jumping up and down when they suddenly get 'the response times we had 3 years ago' (to quote Baxters Soups!) Feel free to contact us or Unbeaten Path for a demo copy of the Archiving or any of our other BPCS add-ons, or to arrange a tuning via dial-up.
Hope this helps, Clare Clare Holtham Director, Small Blue Ltd - Archiving for BPCS Web: www.smallblue.co.uk IBM Certified iSeries Systems Professional Email: Clare.Holtham@xxxxxxxxxxxxxxx----- Original Message ----- From: "Otto Hason" <hason@xxxxxxxx>
To: "SSA's BPCS ERP System" <bpcs-l@xxxxxxxxxxxx> Sent: Thursday, March 16, 2006 4:45 AM Subject: Re: [BPCS-L] ACR900 - too long
Hallo Steve, there are about 150000 records in RAR, 2 deleted (today). Otto----- Original Message ----- From: Steve SegerstromTo: SSA's BPCS ERP System Sent: Wednesday, March 15, 2006 8:58 PM Subject: Re: [BPCS-L] ACR900 - too long How many records are on the rar file? -----Original Message----- Hi all, BPCS v 6.0.04we are unlucky with ACR900 - month end close. Before 3 years it took 1700 s CPU time, now it consumes about 8000 s.-- This is the SSA's BPCS ERP System (BPCS-L) mailing list To post a message email: BPCS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/bpcs-l or email: BPCS-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/bpcs-l. Delivered-To: Clare.Holtham@xxxxxxxxxxxxxx
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.
midrange.com
