Howdy, Stranger!
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
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 304 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
NAV2015 - In-memory tables possible?
Tomigs
Member Posts: 86
Hi experts,
We have heard about the new capacities in using in-memory technology for tables in SQL Server 2014, that apparently can improve significantly the performance of the database (http://www.eweek.com/database/slideshow ... ology.html)
My question is if you know if NAV2015 can benefit from this feature.
I have looked at a very useful topic at Kriki's blog (http://mibuso.com/blogs/kriki/ - "SQL Server 2014 and NAV"). If I have understood well tables should be created in SQL with certain properties, that should also be present in NAV2015 developement environment (or maybe change the table properties directly in SQL). Furthermore, in-memory tables are only available for SQL Enterprise edition. So my guess is that right now NAV2015 won't benefit from it but I'm not sure and I wonder if any of you have studied this topic more carefully and know about it.
Thank you very much,
Tomas.
We have heard about the new capacities in using in-memory technology for tables in SQL Server 2014, that apparently can improve significantly the performance of the database (http://www.eweek.com/database/slideshow ... ology.html)
My question is if you know if NAV2015 can benefit from this feature.
I have looked at a very useful topic at Kriki's blog (http://mibuso.com/blogs/kriki/ - "SQL Server 2014 and NAV"). If I have understood well tables should be created in SQL with certain properties, that should also be present in NAV2015 developement environment (or maybe change the table properties directly in SQL). Furthermore, in-memory tables are only available for SQL Enterprise edition. So my guess is that right now NAV2015 won't benefit from it but I'm not sure and I wonder if any of you have studied this topic more carefully and know about it.
Thank you very much,
Tomas.
0
Answers
Currently they are not possible with standard NAV development environment.
There are a couple things that prevent this.
ALTER TABLE, sp_rename, and adding and removing an index is not supported for memory-optimized tables.
Time Stamp is not supported either.
They are the perfect solution for SIFT for enterprise SQL version. Currently VSIFT (indexed views) a huge problem for Locking.
MS should separate SIFT from indexes. Add a new property called VSIFT and allow a user to group by and SUM. Then store the data an maintain them in the In Memory tables because it Includes in the new architecture a lock-less concurrency model.
They could use it for certain tables like no series line.
Or even a table that keeps track of Entry No for all the subledger.
So non enterprise customer keep VSIFT and for enterprise use memory table. You'll have to ask MS for an answer.
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n