It sounds like you are receiving the entire data set. If this is the case, to Carey's point, try to figure out what changed and only process the delta. You can do this before the data is exposed to AR or after if the necessary data is available to derive which were changed since the last process time. This is usually accomplished by including a last modified time stamp in the source data.
Axton Grams On Mon, Jun 29, 2009 at 8:42 AM, Kelly Deaver<kdea...@kellydeaver.com> wrote: > ** > AIE/EIE is included with CMDB.. to integrate with CMDB tables. Not sure what > data you are updating. > > Kelly Deaver > kdea...@kellydeaver.com > (Yes, I work for BMC. This post reflects the opinions of the poster and not > the official opinion of BMC) > > > > -------- Original Message -------- > Subject: Re: Importing data using Escalations > From: "O'Brien, Keith KOB. (Citco)" <kobr...@citco.com> > Date: Mon, June 29, 2009 7:52 am > To: arslist@ARSLIST.ORG > > ** > I presume AIE/EIE will cost, is there any other free options? > > Regards, > Keith. > ________________________________ > From:Action Request System discussion list(ARSList) > [mailto:arsl...@arslist.org] On Behalf Of Kelly Deaver > Sent: 29 June 2009 12:54 > To: arslist@ARSLIST.ORG > Subject: Re: Importing data using Escalations > > AIE is mult-threaded now too. > > Kelly Deaver > kdea...@kellydeaver.com > (Yes, I work for BMC. This post reflects the opinions of the poster and not > the official opinion of BMC) > > > > -------- Original Message -------- > Subject: Re: Importing data using Escalations > From: Axton <axton.gr...@gmail.com> > Date: Sun, June 28, 2009 8:29 pm > To: arslist@ARSLIST.ORG > > Here are a couple of alternatives: > - Use AIE/EIE to schedule the load (do the same thing your escalation does) > - Write a program to process the load (do the same thing as the > escalation, but multi-threaded) > > Axton Grams > > On Sun, Jun 28, 2009 at 4:16 PM, O'Brien, Keith KOB. > (Citco)<kobr...@citco.com> wrote: >> ** >> >> We source data via a view form in our Datawarehouse (oracle 9) >> >> We are running AR v7.1 on a separate server with Oracle 10. - so a DBLINK >> is >> used. >> >> We have an escalation that polls that data nightly, but the record set has >> increased to over 350,000 records >> >> Which we need to keep in sync. >> >> The problem is that escalation takes too long to run, hours. >> >> >> >> Is there a better approach to keep this data in sync? >> >> >> >> Regards, >> Keith. >> >> >> >> Disclaimer link. To see it, click the link below, or copy and paste it >> into >> your browser's address line. http://www.citco.com/emaildisclaimer.htm >> >> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers >> Are"_ > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" > > Disclaimer link. To see it, click the link below, or copy and paste it into > your browser's address line. http://www.citco.com/emaildisclaimer.htm > _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers > Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the > Answers Are"_ > > _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers > Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
