Anything at the DB layer will be faster than an escalation which relies on the app stack. As long as you are comfortable that there is no workflow that runs on delete that would otherwise compromise your data integrity
Sent from my iPhone > On Jul 21, 2017, at 4:56 PM, Harsh <chaudhar...@gmail.com> wrote: > > ** Hi All, > > Today i got into an argument where one of > my colleague was deleting 57K records from custom form through Escalations. I > asked him to better use a delete query on arsystem database. As it will > delete the records faster then escalations. > > As per him both will take same amount of time. But i believe escalation will > take more time as it has to make a call to DB everytime and somehow will add > the processing time on the server. > > Please let me know your thoughts upon the same. > > Thanks, > Harsh > > > -- > Thanks & regards > “Harsh Chaudhary” > "Impatience never commanded success" > > > _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"
