Transaction History Updates Slow


  • Hello ...

    i have created a transaction history table that now contain 10000 row , in some case  i want to delete row , this deletion caused a large number of updates for material and underline other items , 

    the deletion process take large amount of time and this represent a big problem for me ,

    this table has on delete trigger that update the underline data, and also i am used a nested cursors in these triggers to update nested data ,

    what is the best way to reduce the time of delete process

    Wednesday, March 05, 2014 12:55 PM


All replies