After updating a system from NAV 2009 R2 to NAV 2013 we are suddenly experiencing mayor performance problems when opening the chart of account view. (Around 8 sec’s to open and 8 secs load time for every page down). More or less the pages is not useable.
As far as we know the changes made to SIFT in NAV 2013 should improve performance but here this does not seem to be the case…. Using the SQL profiler is seems that NAV is now generating one big script to calculate the SIFTs using OUTER APPLY per calculated field. Where NAV 2009 seemed to fire of individual sum commands to the SQL server.
Just for info there is around 800 accounts in the table and around 340.000 entries in the G/L Entry table spread over 15 years. So nothing really big…. And I therefore wonder if this is a problem with only our system or a general problem. I would have thought that the Chart of accounts would be one of the main areas for MS to do performance testing and that they would have noticed such a problem.
We have analyzed all the indexes and they are fully optimized and the sifts are also activated (deactivating them has also been tried but without any positive effect)
On NAV 2009 R2 RTC the Chart of accounts work ok (maybe 1-1.5 sec delay to open).
Does anybody else have the same experience with NAV 2013? Any solutions/work around?