"optimizing-sift-and-vsift" - 10 year ol article on dynamicsuser.net

jensthomsen
Member Posts: 173
Hi
I stumbled over this interesting article by Jörg Stryk: https://dynamicsuser.net/nav/b/stryk/posts/optimizing-sift-and-vsift
It is (more than) 10 years old, but the question is: Is it still relevant? More precisely for Nav 2017 and onwards.
I stumbled over this interesting article by Jörg Stryk: https://dynamicsuser.net/nav/b/stryk/posts/optimizing-sift-and-vsift
It is (more than) 10 years old, but the question is: Is it still relevant? More precisely for Nav 2017 and onwards.
0
Answers
-
I think this is more a SQL-related question then a NAV version question. The calculated fields are still not stored in the database, this was the case in the old character based Navision 3.56(a) in 1996, with an own database engine, and still in SQL. (SQL) queries can not query calculated fields, like the stock qty of an item or the balance of a customer. NAV is calculating these values "on the fly", but how they are technically stored, I do not know. In the character based version the sum was partly stored in the index tables, in order to avoid huge calculations when records got updated. This will still be there, up to some level.
It is interesting to know these techniques, but for a "regular NAV programmer" these techniques happen under the hood, and you do not need to kow exactly how they work.IF User.Loves('Edo') THEN ok() ELSE currReport.genSkip;0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions