run adjust cost item entries are very slow on NAV2009

NW-Dev

Does anyone have a good way to speed up adjust cost item entries process?

I have upgrade from NAV5Sp1 native to SQL NAV2009 and it take 5 times double from the old version.

kriki

Use the client monitor (or even better : SQL traces) to see what SQL-statements are sent to the server. Maybe some index or SIFT is missing.

dvd679

Did you manage to solve this. I am experiencing same problem with an upgrade from NAV4.03 to NAV 6 SP1.

kriki

Best try the method I described earlier to see what is happening on SQL Server.