hiya guys, i’m andre, a newbie here
i want to make adjust costing (NAV4 SP2) operation faster
by using SQL20005 table partitioning method
here’s my question :
- which table in SQL that i should choose to part?
- or if i have to find it myself,
is there any tools in SQL that could trace the involved table during the operation (read/write/update)?
previously, i already some suggested method to get an improvement:
- table partition (by guessing) on item ledger enty (ILE) by using entry no. as the separator and put it on the different disk
- rebuilt database index (as suggested by Tuning Navision for better peformance rev 5 - Patrice Dupont)
so far those method doesnt give me any improvement (due to an adjust costing).
is there something that i miss, so those method failed?
or adjust costing is not affected with those method because the main problem is in the C/AL CODE?
i’m kinda new in this area, so i really appreciated for any suggestion and input. thks
PS :
i also post this at mibuso (http://www.mibuso.com/forum/viewtopic.php?p=102479)