LJ, can we have your tool as a API Filter plugin?
Thomas > On 21. Jul 2017, at 23:29, LJ LongWing <[email protected]> wrote: > > ** > 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_ > > _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"
