Harsh, Deleting from the DB will always be faster than deleting from the applications server because you are removing the overhead of the Remedy server, that being said however, I always do my deletes against the app server. I do this for many reasons, but data integrity is one of them. When you do your deletes through the app server, you get 'all' of the pieces that you are supposed to get (T, H, B, BNCN)....for this reason, deleting though the app server is preferred, from my perspective at least. With this thought in mind, I have produced a tool that I have used personally for several years, and with the assistance of Jason Miller, moved more mainstream and increased performance from it by making it multi-threaded.
http://remedylegacy.com/tools/delete-requests/ This tool uses an SQL query to identify the records that need to be removed, and then uses the api to do the actual removal. Because it's using the API, it'll make any workflow that fires on delete fire, which can cause you do have a cascade effect cleaning up parent/child/grandchild/etc relationships.... In general, I recommend not doing anything with the Remedy DB directly at the DB level, there are of course all sorts of people that do with no impact at all, or no noticeable impact, but in general, having done Remedy for as many years a I have....I believe the data should be inserted into, modified, and removed from the Remedy DB by the Remedy application server... On Fri, Jul 21, 2017 at 2:56 PM, Harsh <[email protected]> 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"
