apply to item entry in sales line table slows down the systm

nrapendra

hi all,

at the time of making sales invoice we have to apply item ladter entry no whose stock is going to be less.but when we select the entry the system takes 10-15 minuts in applying the entry.i have tested it iin dibugger,
i found that it is slow in line where exit is used in any function.

is there any solution of this problem.


Nrapendra Singh

garak

Nav 4.xx and SQL 2005 :?:

girish.joshi

I didn't think ti was possible to use the debugger to diagnose performance problems.

Run the client monitor, find out where it is getting stuck. My guess is that it is a problem with a) index doesn't exist b) code isn't using a key

Can't go any further without information about your setup though. As garak said, version of NAV and SQL version please.