My recommendation would be to do a run process. Like everyone else is saying, the best way to run an escalation is to use a form just for escalations. One record per escalation. That way you have a small amount of records for it to walk over. Then use a filter to perform the work.
When you run the escalation on a form, it reviews EVERY record in that form and if it passes the qualification fires the work for that record. Then again for each record it finds. If it finds ANY it does NOT fire the else action. If it finds NONE it will fire the ELSE action ONCE. If you run the process below, it will perform the updates to the server in a MUCH faster manner. This run process command can only be performed in a filter or an escalation. Application-Query-Delete-Entry "form" qualificationString Brian Goralczyk Phone 574-643-1144 Email [email protected] On Thu, Aug 15, 2013 at 5:54 PM, Kathy Morris <[email protected]>wrote: > ** > > ** ** > > I had to shut off the escalations because our system was hung. There were > over 36,000 records. Yesterday there were over 500,000 records. I did > know there was a multi thread delete. Is this in Oracle?**** > > ** ** > > Thanks so much. I have been struggling with this all day.**** > > ** ** > > *From:* Action Request System discussion list(ARSList) [mailto: > [email protected]] *On Behalf Of *Brian Goralczyk > *Sent:* Thursday, August 15, 2013 5:47 PM > *To:* [email protected] > *Subject:* Re: SQL Query**** > > ** ** > > ** **** > > Do NOT use an escalation. It will review all the rows. Unless you are > running it on a different table that doesn't have a lot of rows and doing a > delete from that.**** > > ** ** > > You want to make sure you do a multi thread delete and not a single thread > delete.**** > > ** ** > > What DB are you using?**** > > ** ** > > If you are using Oracle I could give you an sample sql statement that > would delete what you need fairly painlessly.**** > > ** ** > > Brian Goralczyk**** > > > **** > > Brian Goralczyk**** > > Phone 574-643-1144**** > > Email [email protected] > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"

