Browse Site by Tags - Dynamics User Group

Downgrading NAV

Well, a current discussion is whether to go for NAV 5.0 Service Pack 1 or not. On the one hand, NAV 5.0 SP1 has lots of improvements regarding SQL performance (Indexed Views, Buffered Inserts, etc.), on the other hand there are other issues and problems (slow FlowFields, lacking SQL 2000 capability,...

Posted to Dynamics NAV Performance on SQL - My Two Cents by Jörg A. Stryk on 06-05-2008
Filed under: Performance, SIFT, NAV, vsift, sql server, 5.0 sp1, upgrade, downgrade

Re: Dynamics and SQL Reporting Services

I think we are all getting crossed lines here the biggest issue that I see is that SQL does not support flow fields. So they are instead generated on the fly with scripts, that aintaint ht eSIFT fields in seperate tables, and that does cause performance issues. It would be great if SQL incorporated SIFT...

Posted to Dynamics User Group - Membership Questions by David Singleton on 05-10-2006

Re: Dynamics and SQL Reporting Services

@David I agree that in Navision the flowfields are indeed very powerful and useful. However, the way they have been implemented in SQL causes a lot of extra overhead when you are writing to the database. Each key which uses SIFT creates another table in SQL which needs to get updated via a trigger when...

Posted to Dynamics User Group - Membership Questions by Steveno on 05-04-2006