Re: ACR900 - too long

["Clare Holtham" <clare.holtham@xxxxxxxxxxxxxx>]

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 Segerstrom
>  To: 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.04
>  we 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