Hi, just an additional idea:
you could use the (by BMC unsupported) ardelete step for spoon written by Sebastian Schmidt: https://sourceforge.net/projects/arsoutputplugin/?source=navbar When you have PDI7 as stand alone you can download it from the Petaho Plugin Marketplace and it will be installed correctly for use. The "new" PDI 6 version that is shipped with ARS 9.1.3 does not have the Marketplace. my 2 cents Regards Rüdiger ** > Thomas Miskiewicz <[email protected]> hat am 22. Juli 2017 um 10:02 > geschrieben: > > > LJ, > > can we have your tool as a API Filter plugin? > > > Thomas > > On 21. Jul 2017, at 23:29, LJ LongWing <[email protected] > mailto:[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] > > mailto:[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_ > > > > > > _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"
