Re: Reconciliation speed

2014-06-24 Thread William Rentfrow
t@ARSLIST.ORG Subject: Re: Reconciliation speed Make sure the reconciliation job is only merging changed CIs ... we saw this same problem with the OOTB ADDM job ... every night it was updating the unchanged CIs as well. We went from 11.5 hours to 6.0 minutes after unchecking the box. Thanks! .: Mike T

Re: Reconciliation speed

2014-06-23 Thread Mike Tomasiewicz (ConAgra Foods)
: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of William Rentfrow Sent: Monday, June 23, 2014 3:05 PM To: arslist@ARSLIST.ORG Subject: Re: Reconciliation speed This is a merge job which is running ADDM data into BMC Asset. We haven't customize

Re: Reconciliation speed

2014-06-23 Thread William Rentfrow
l investigating that route as well. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mueller, Doug Sent: Monday, June 23, 2014 2:53 PM To: arslist@ARSLIST.ORG Subject: Re: Reconciliation speed William, OK, this seems to be pa

Re: Reconciliation speed

2014-06-23 Thread Mueller, Doug
hin a reconciliation run. Doug Mueller -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of William Rentfrow Sent: Monday, June 23, 2014 12:17 PM To: arslist@ARSLIST.ORG Subject: Re: Reconciliation speed ***Re-sending as plain

Re: Reconciliation speed

2014-06-23 Thread William Rentfrow
t@ARSLIST.ORG] On Behalf Of Mueller, Doug Sent: Monday, June 23, 2014 1:29 PM To: arslist@ARSLIST.ORG Subject: Re: Reconciliation speed ** William, I don't have an point answer, but some thoughts.. First, remember there is a major difference between a FIRST run of reconciliation to get

Re: Reconciliation speed

2014-06-23 Thread William Rentfrow
ue obviously.  T525 is BMC.CORE.BMC_Impact_D, which is of course an inner join form (WHY?! WHY?! WHY!?!?!) of BMC Base Relationship to itself. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Peter Romain Sent: Monday, June 23, 2014 1:09 PM To

Re: Reconciliation speed

2014-06-23 Thread William Rentfrow
014 1:29 PM To: arslist@ARSLIST.ORG Subject: Re: Reconciliation speed ** William, I don't have an point answer, but some thoughts First, remember there is a major difference between a FIRST run of reconciliation to get all the data established and the ongoing nightly (or hourly or con

Re: Reconciliation speed

2014-06-23 Thread William Rentfrow
--_000_0a2f9cdf5f2d4cc296c7484f1f8c7347CO1PR07MB144namprd07pro_ Content-Transfer-Encoding: base64 Content-Type: text/plain; charset="utf-8" SSd2ZSBkb25lIHNvbWUgbW9yZSBkaWdnaW5nIGFuZCBJIGZvdW5kIHNvbWUgImdlbml1cyIgU1FM Lg0KDQpGb3IgZXZlcnkgdXBkYXRlLCB0aGlzIFNRTCBpcyBydW4gcHJpb3IgdG8gdGhlIHVwZGF0 ZSAt

Re: Reconciliation speed

2014-06-23 Thread Mueller, Doug
st System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of William Rentfrow Sent: Monday, June 23, 2014 9:43 AM To: arslist@ARSLIST.ORG Subject: Reconciliation speed ** Hi - We're trying to get our recon jobs faster. We have hundreds of thousands of CI's in certain clas

Re: Reconciliation speed

2014-06-23 Thread Peter Romain
: 23 June 2014 17:48 To: arslist@ARSLIST.ORG Subject: Re: Reconciliation speed ** Drop the indexes on the destination forms? Rick On Jun 23, 2014 9:47 AM, "William Rentfrow" mailto:wrentf...@stratacominc.com> > wrote: ** Hi - We're trying to get our recon

Re: Reconciliation speed

2014-06-23 Thread Rick Cook
Drop the indexes on the destination forms? Rick On Jun 23, 2014 9:47 AM, "William Rentfrow" wrote: > ** > > Hi - > > > > We're trying to get our recon jobs faster. We have hundreds of thousands > of CI's in certain classes and we will have over a million in some other > classes. > > > > Right n

Reconciliation speed

2014-06-23 Thread William Rentfrow
Hi - We're trying to get our recon jobs faster. We have hundreds of thousands of CI's in certain classes and we will have over a million in some other classes. Right now we're getting about 7000 per hour - which means the tool are basically unusable because it takes waaay too l