Meta-Update has had a delete capability for 17 years. It also comes with Meta-Delete, a stand alone delete tool. Caution. Whilst the delete workflow has gotten better through the releases, it still leaves dangling records. Always delete lower level records first for performance. The delete workflow is basically a delete signal push fields to children records. Ben Chernyswww.softwaretoolhouse.com
Sent from my Samsung Galaxy smartphone. -------- Original message --------From: LJ LongWing <lj.longw...@gmail.com> Date: 22/07/2017 06:47 (GMT-07:00) To: arslist@ARSLIST.ORG Subject: Re: Delete Through Escalation vs Delete through DB ** Thomas,Yes...it could be done as an API Filter Plugin....I've been thinking about that since you asked....the only problem I can see with a Filter Plugin would be the feedback portion. As it is, running it, you get the feedback in the log about what was attempted, what was executed, etc...I could output all of that to the plugin log through normal channels if that would be ok....I'd just never thought of doing it through a plugin before.... On Sat, Jul 22, 2017 at 2:02 AM, Thomas Miskiewicz <tmisk...@gmail.com> wrote: ** LJ, can we have your tool as a API Filter plugin? Thomas On 21. Jul 2017, at 23:29, LJ LongWing <lj.longw...@gmail.com> 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 <chaudhar...@gmail.com> wrote: ** Hi All, Today i got into an argument where one ofmy 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_ _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"