No, about the only thing that would help would be to limit the returned result to 500, which would cause TONS of other problems elsewhere in the system.
On Mon, Sep 8, 2014 at 10:33 AM, Jayesh <jhpancha...@gmail.com> wrote: > ** > Will server-side-table-chunk-size = 500 help? > ------------------------------ > From: MalviyaSaurabh <malviya.saurab...@gmail.com> > Sent: 08-09-2014 04:46 PM > To: arslist@ARSLIST.ORG > Subject: Escalation qualification : DSO > > Hi All, > I am in the process of archiving records in remedy. I have written an > escalation with DSO action written which is working. I have the escalation > qualification as > ( 'Ticket Closed Date' <= "2/28/2009 11:59:59 PM") AND ( 'Status' = > "Closed") AND ( 'Ticket Closed Date' >= "1/1/2009 12:00:00 AM") > As over 1 lac record are there in this timespan, there are overhead issues > happening at the db level. > > Is there any way we can have the escalation run in batches of say 500 > records present in this qualification. > > Regards, > Saurabh > > > > -- > View this message in context: > http://ars-action-request-system.1.n7.nabble.com/Escalation-qualification-DSO-tp118847.html > Sent from the ARS (Action Request System) mailing list archive at > Nabble.com. > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > "Where the Answers Are, and have been for 20 years" > _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
