Browse by Tags

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 (Weblog) by Jörg A. Stryk on 06-05-2008
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 (Forum) 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 (Forum) by StevenO on 05-04-2006

Page 1 of 1 (3 items)

Dynamics User Group