{"id":43344,"date":"2014-11-12T08:00:00","date_gmt":"2014-11-12T08:00:00","guid":{"rendered":"https:\/\/blogs.msdn.microsoft.com\/nav\/2014\/11\/12\/microsoft-dynamics-nav-faster-than-ever\/"},"modified":"2023-05-31T15:46:06","modified_gmt":"2023-05-31T22:46:06","slug":"microsoft-dynamics-nav-faster-than-ever","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/no-audience\/2014\/11\/12\/microsoft-dynamics-nav-faster-than-ever\/","title":{"rendered":"Microsoft Dynamics NAV: Faster than ever."},"content":{"rendered":"<p>&nbsp;<\/p>\n<p>First,\u00a0let me start by saying that\u00a0based on\u00a0the\u00a0evidence so far: It is. Significantly.<\/p>\n<p>A number of the changes to the Dynamics NAV 2013 architecture contribute to the performance boosts that many of the test have shown. To outline some of the changes:<\/p>\n<ul>\n<li>Middle tier is 64 bit<\/li>\n<li>We are no longer using cursors but MARS<\/li>\n<li>Ability to auto-update sift fields when looping, rather than repeating the process for each call. SETAUTOCALCFIELDS reduces the amount of statements issued<\/li>\n<li>Pages containing flowfields now issue \u2018SmartSQL\u2019 queries, basically one source table query with outer joins for each flowfield query, again reducing the \u2018chattiness\u2019<br \/>\nand calculating sift values in one server roundtrip<\/li>\n<li>Global cache<\/li>\n<li>REPEATABLEREAD is default isolation level<\/li>\n<li>Locking changes in posting routines, locking at later point and reducing overall blocking time<\/li>\n<\/ul>\n<p>\u2026 and more.<\/p>\n<p>However(!), a few things have surfaced in the course of time that are not as explicitely documented as the changes above, nor as apparent, and might\u00a0have unexpected side effects. I have collected some of the side effects that you might or not be aware of and that might leave you panicking if not certain what you\u2019re facing.<\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li>Pages (with FlowFields) will in general run faster on Dynamics NAV 2013 than on NAV 2009 due to SmartSQL queries and reduced chattiness. Flow Fields on a page (all of them) are calculated in one go, which greatly reduces number of statements issued. But SmartSQL queries are not cached. Also, since we changed to MARS, SQL seems to be more sensitive to an index&#8217;s column cardinality then before. You might experience that (depending on various factors) some queries that have run fine in the past now take much longer, this is\u00a0due to a poor execution plan on SQL. With Dynamic cursors, query plan optimizer tended to optimize for the ORDER BY, while with MARS, SQL is free to choose.\u00a0 It does a good job at it too, but in rare occasions might chose poorly. These cases are exceptions and contrary to the popular belief, this is not caused by the SmartSQL queries. These queries will have same poor execution plan and perform poorly even when isolated from the SmartsSQL query.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p style=\"padding-left: 60px\">Consider the following example. This is just an illustration of the problem, constructed on CRONUS extended database:<\/p>\n<p style=\"padding-left: 60px\">A lot of Inventory transactions are\u00a0posted through\u00a0the Item Journal,\u00a0generating a lot of Post cost to the G\/L Entry. After this, when browsing an item list and opening an Item card, the page opens very slowly.<\/p>\n<p style=\"padding-left: 60px\">After locating the offending query in the\u00a0SQL profiler and running it isolated in Microsoft SQL Server Management Studio with \u2018Include Actual Execution Plan\u2019 option enabled, the plan looks similar to the one shown below:<\/p>\n<p style=\"padding-left: 60px\">\u00a0<a href=\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-content\/uploads\/2014\/11\/1526.plan1_.png\"><img decoding=\"async\" alt=\"\" src=\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-content\/uploads\/2014\/11\/1526.plan1_.png\" border=\"0\" \/><\/a><\/p>\n<p style=\"padding-left: 30px\">\n<p style=\"padding-left: 60px\">Each sub-query shows reasonably (small) percentage of cost and no apparent reason for bad execution plan. There are no obvious extreme costs, however there is a Clustered Index Scan here:<\/p>\n<p style=\"padding-left: 60px\"><a href=\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-content\/uploads\/2014\/11\/4087.plan2_.png\"><img decoding=\"async\" alt=\"\" src=\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-content\/uploads\/2014\/11\/4087.plan2_.png\" border=\"0\" \/><\/a><\/p>\n<p style=\"padding-left: 60px\">Looking at the filter that SQL Server applies, namely it filters on \u201cPost Value Entry to G_L\u201d. \u201cItem_No_\u201d = \u201cItem\u201d.\u201dNo_\u201d:<\/p>\n<p style=\"padding-left: 60px\">\u00a0<a href=\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-content\/uploads\/2014\/11\/3364.planx_.png\"><img loading=\"lazy\" decoding=\"async\" width=\"260\" height=\"311\" alt=\"\" src=\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-content\/uploads\/2014\/11\/3364.planx_.png\" border=\"0\" \/><\/a><\/p>\n<p style=\"padding-left: 60px\">\n<p style=\"padding-left: 60px\">Although SQL Server reports Operator Cost as small, it shows CPU Cost in excess of 2.3 in approx. 1.94 executions. So, it is likely scanning the table twice and unfortunately the table has 4,7 million rows.<\/p>\n<p style=\"padding-left: 60px\">Although it is not obvious from the actual SQL Server execution plan that this is a problem, profiling with the SQL Server Profiler reports the query to use more than 5 seconds of CPU, while doing 131.519 reads to fetch 52 rows:<\/p>\n<p style=\"padding-left: 60px\">\n<a href=\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-content\/uploads\/2014\/11\/5635.plan3_.png\"><img decoding=\"async\" alt=\"\" src=\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-content\/uploads\/2014\/11\/5635.plan3_.png\" border=\"0\" \/><\/a><\/p>\n<p style=\"padding-left: 60px\">The reason the Duration is on par with CPU Seconds is that all reads are logical from SQL Server Buffers. Re-issuing the query after adding the supporting index shows this in SQL Server Profiler:<\/p>\n<p style=\"padding-left: 60px\">\u00a0<a href=\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-content\/uploads\/2014\/11\/2804.plan4_.png\"><img decoding=\"async\" alt=\"\" src=\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-content\/uploads\/2014\/11\/2804.plan4_.png\" border=\"0\" \/><\/a><\/p>\n<p style=\"padding-left: 60px\">So Reads were\u00a0reduced by a factor of 100 and (warm) duration was reduced by a factor of 40.<\/p>\n<p style=\"padding-left: 60px\">As you can see, these poor execution plans are not caused by the SmartSQL.\u00a0However the fact that the SmartSQL queries don\u2019t cache their results will only amplify the issue. To solve it,\u00a0we have\u00a0to tackle the performance of that one isolated query by creating a covering index to improve the execution plan.<\/p>\n<p style=\"padding-left: 60px\">And no, it won\u2019t help to merely customize the page or change the visibility of the field. As long as it is contained in page metadata (so unless removed from page altogether), it will be calculated.<\/p>\n<p style=\"padding-left: 60px\">So in short, if you do run into an issue of rather dramatic slowness of a page containing flowfields in Dynamics NAV 2013 or higher, isolating and testing the Flow Field queries separately (focusing on ones with clustered index scan, regardless of cost) should lead you to the culprit fairly quickly.\u00a0 A supporting index should resolve the problem.<\/p>\n<ul>\n<li>\n<div style=\"padding-left: 30px\">Temp tables: These are now moved to .NET. When you create a Temp record, your private C# TempTableDataProvider object is created. It will store whatever records you insert into a C# Dictionary, with the Primary Key Fields as the key for the Dictionary. The Dictionary is in memory and stores records in the order they<br \/>\nare inserted. \u00a0When you\u00a0add\u00a0a SetCurrentKey, an AVLTree is built on the fly at first FindXX() you perform with that (current) key. In terms of performance, this is an expensive operation. This tree is in memory however, so it will be cached and reused later. If you issue a query without calling SetCurrentKey, an AVLTree for the primary key will be used.<\/div>\n<\/li>\n<\/ul>\n<p style=\"padding-left: 60px\">However, maintaining all this can consume quite a lot of\u00a0memory on your middle tier, so plan for ample\u00a0memory\u00a0when scaling. Also, as mentioned above, querying temp tables is cached but sorting them is a fairly expensive operation, just something to keep in mind.<\/p>\n<ul>\n<li>The next one is not strictly a performance issue, but can have a fairly drastic performance side-effect if you\u2019re affected by it, so deserves to be mentioned:<\/li>\n<\/ul>\n<p style=\"padding-left: 60px\">You might (or might not) be aware that the transaction scope and behavior of a page action has changed in Microsoft Dynamics NAV 2013 and higher. This will be especially significant if you are calling functions in codeunits (or objects other than the source table), passing the REC as a parameter and intend to lock the record in that function.<\/p>\n<p style=\"padding-left: 60px\">Consider the following example: You have added an action that invokes a function in a codeunit, that in turn locks\/ modifies the record (typically calling custom posting routine)<\/p>\n<p style=\"padding-left: 60px\">So OnAction trigger code is, for example, as follows:<\/p>\n<p style=\"padding-left: 30px\">\n<p style=\"padding-left: 90px\">\u00a0 PostingFunction(Rec);<\/p>\n<p style=\"padding-left: 30px\">\n<p style=\"padding-left: 60px\">Where PostingFunction is a function (in any object other than the source table).<\/p>\n<p style=\"padding-left: 60px\">Now, the consequence of the previously mentioned transaction scope change and the fact that you\u2019re locking the record in the function, is that the entire source table (Rec) you passed as a parameter in the example above, is locked. In other words, you\u2019re passing the current record as a parameter, but you are locking the whole table. The behavior would cause more damage than good to change at this point due to all functionality it would affect, so it won\u2019t be changed, but fortunately \u2013 if<br \/>\nyou\u2019re aware of this issue, the solution is very simple:<\/p>\n<p style=\"padding-left: 60px\">SETSELECTINOFILTER(Rec);\u00a0 \/\/adding this line<\/p>\n<p style=\"padding-left: 60px\">PostingFunction(Rec);<\/p>\n<p style=\"padding-left: 60px\">Adding the line above should reduce the scope of locking and leave you with locking just the one record (or selection of records if on\u00a0a list). This applies to card pages as well.<\/p>\n<p style=\"padding-left: 30px\">\n<ul>\n<li>Last, but not least: you might have noticed increased Async_Network_IO waits. These cause quite a lot of concern out there. However, this is a symptom and not a problem per se.<\/li>\n<\/ul>\n<p style=\"padding-left: 60px\">When Dynamics NAV issues a query that returns thousands of rows, SQL Server will start a work thread to return the result. If the application does not consume the rows as fast as they are delivered from SQL Server then the SQL Server work thread will have to wait and that shows up as wait type Network_Async_IO. If the application never consumes the entire result set then the worker thread will be hanging until the transaction is ended (when we close the statement), or if it was a read transaction, for a longer period either until the connection is closed (as idle) or if the statement is overwritten by another statement (statement cache is full).<\/p>\n<p style=\"padding-left: 60px\">Example: when we do a FINDSET, a number of records (50, 100&#8230;) is retrieved. If it is a larger set it will run until all records are retrieved (or buffer is full), even if only first 10 are actually read by application. Eventually the session goes to sleep and after transaction ends sleeping sessions are removed. So in short, these are merely reflecting NAV data access methods, and are not\u00a0a problem\u00a0as such.\u00a0If you want to\u00a0reduce these, make sure you\u2019re reading all the rows you\u2019re asking for when using FINDSET, otherwise use FIND(\u2018-\u2018) or FIND(\u2018+\u2019).<\/p>\n<p style=\"padding-left: 30px\">\n<p style=\"padding-left: 30px\">With thanks to Jesper Falkebo and Jens Klarskov Jensen<\/p>\n<p style=\"padding-left: 30px\">\n<p style=\"padding-left: 30px\">Jasminka Thunes<\/p>\n<p style=\"padding-left: 30px\">Microsoft CSS<\/p>\n<p style=\"padding-left: 30px\"><strong><em>\u00a0<\/em><\/strong><\/p>\n<p style=\"padding-left: 30px\"><strong><em>These postings are provided &#8220;AS IS&#8221; with no<br \/>\nwarranties and confer no rights. You assume all risk for your use.<\/em><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; First,\u00a0let me start by saying that\u00a0based on\u00a0the\u00a0evidence so far: It is. Significantly. A number of the changes to the Dynamics NAV 2013 architecture contribute to the performance boosts that many of the test have shown. To outline some of the changes: Middle tier is 64 bit We are no longer using cursors but MARS<\/p>\n","protected":false},"author":4544,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ms_queue_id":[],"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","footnotes":""},"post_tag":[],"product":[],"content-type":[4690],"topic":[],"audience-type":[],"audience":[],"ms-author":[],"coauthors":[4306],"class_list":["post-43344","post","type-post","status-publish","format-standard","hentry","content-type-news-and-product-updates"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.7 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Microsoft Dynamics NAV: Faster than ever. - Microsoft Dynamics 365 Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/no-audience\/2014\/11\/12\/microsoft-dynamics-nav-faster-than-ever\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Microsoft Dynamics NAV: Faster than ever. - Microsoft Dynamics 365 Blog\" \/>\n<meta property=\"og:description\" content=\"&nbsp; First,\u00a0let me start by saying that\u00a0based on\u00a0the\u00a0evidence so far: It is. Significantly. A number of the changes to the Dynamics NAV 2013 architecture contribute to the performance boosts that many of the test have shown. To outline some of the changes: Middle tier is 64 bit We are no longer using cursors but MARS\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/no-audience\/2014\/11\/12\/microsoft-dynamics-nav-faster-than-ever\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Dynamics 365 Blog\" \/>\n<meta property=\"article:published_time\" content=\"2014-11-12T08:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-05-31T22:46:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-content\/uploads\/2014\/11\/1526.plan1_.png\" \/>\n<meta name=\"author\" content=\"Jasminka Thunes\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jasminka Thunes\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/no-audience\/2014\/11\/12\/microsoft-dynamics-nav-faster-than-ever\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/no-audience\/2014\/11\/12\/microsoft-dynamics-nav-faster-than-ever\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/author\/jthunes\/\",\"@type\":\"Person\",\"@name\":\"Jasminka Thunes\"}],\"headline\":\"Microsoft Dynamics NAV: Faster than ever.\",\"datePublished\":\"2014-11-12T08:00:00+00:00\",\"dateModified\":\"2023-05-31T22:46:06+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/no-audience\/2014\/11\/12\/microsoft-dynamics-nav-faster-than-ever\/\"},\"wordCount\":1508,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/no-audience\/2014\/11\/12\/microsoft-dynamics-nav-faster-than-ever\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-content\/uploads\/2014\/11\/1526.plan1_.png\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/no-audience\/2014\/11\/12\/microsoft-dynamics-nav-faster-than-ever\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/no-audience\/2014\/11\/12\/microsoft-dynamics-nav-faster-than-ever\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/no-audience\/2014\/11\/12\/microsoft-dynamics-nav-faster-than-ever\/\",\"name\":\"Microsoft Dynamics NAV: Faster than ever. - Microsoft Dynamics 365 Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/no-audience\/2014\/11\/12\/microsoft-dynamics-nav-faster-than-ever\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/no-audience\/2014\/11\/12\/microsoft-dynamics-nav-faster-than-ever\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-content\/uploads\/2014\/11\/1526.plan1_.png\",\"datePublished\":\"2014-11-12T08:00:00+00:00\",\"dateModified\":\"2023-05-31T22:46:06+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/no-audience\/2014\/11\/12\/microsoft-dynamics-nav-faster-than-ever\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/no-audience\/2014\/11\/12\/microsoft-dynamics-nav-faster-than-ever\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/no-audience\/2014\/11\/12\/microsoft-dynamics-nav-faster-than-ever\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-content\/uploads\/2014\/11\/1526.plan1_.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-content\/uploads\/2014\/11\/1526.plan1_.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/no-audience\/2014\/11\/12\/microsoft-dynamics-nav-faster-than-ever\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Microsoft Dynamics NAV: Faster than ever.\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/\",\"name\":\"Microsoft Dynamics 365 Blog\",\"description\":\"Modernizing Business Process with Cloud and AI\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/#organization\",\"name\":\"Dynamics 365 Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"width\":259,\"height\":194,\"caption\":\"Dynamics 365 Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Microsoft Dynamics NAV: Faster than ever. - Microsoft Dynamics 365 Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/no-audience\/2014\/11\/12\/microsoft-dynamics-nav-faster-than-ever\/","og_locale":"en_US","og_type":"article","og_title":"Microsoft Dynamics NAV: Faster than ever. - Microsoft Dynamics 365 Blog","og_description":"&nbsp; First,\u00a0let me start by saying that\u00a0based on\u00a0the\u00a0evidence so far: It is. Significantly. A number of the changes to the Dynamics NAV 2013 architecture contribute to the performance boosts that many of the test have shown. To outline some of the changes: Middle tier is 64 bit We are no longer using cursors but MARS","og_url":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/no-audience\/2014\/11\/12\/microsoft-dynamics-nav-faster-than-ever\/","og_site_name":"Microsoft Dynamics 365 Blog","article_published_time":"2014-11-12T08:00:00+00:00","article_modified_time":"2023-05-31T22:46:06+00:00","og_image":[{"url":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-content\/uploads\/2014\/11\/1526.plan1_.png","type":"","width":"","height":""}],"author":"Jasminka Thunes","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Jasminka Thunes","Est. reading time":"6 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/no-audience\/2014\/11\/12\/microsoft-dynamics-nav-faster-than-ever\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/no-audience\/2014\/11\/12\/microsoft-dynamics-nav-faster-than-ever\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/author\/jthunes\/","@type":"Person","@name":"Jasminka Thunes"}],"headline":"Microsoft Dynamics NAV: Faster than ever.","datePublished":"2014-11-12T08:00:00+00:00","dateModified":"2023-05-31T22:46:06+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/no-audience\/2014\/11\/12\/microsoft-dynamics-nav-faster-than-ever\/"},"wordCount":1508,"commentCount":0,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/no-audience\/2014\/11\/12\/microsoft-dynamics-nav-faster-than-ever\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-content\/uploads\/2014\/11\/1526.plan1_.png","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/no-audience\/2014\/11\/12\/microsoft-dynamics-nav-faster-than-ever\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/no-audience\/2014\/11\/12\/microsoft-dynamics-nav-faster-than-ever\/","url":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/no-audience\/2014\/11\/12\/microsoft-dynamics-nav-faster-than-ever\/","name":"Microsoft Dynamics NAV: Faster than ever. - Microsoft Dynamics 365 Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/no-audience\/2014\/11\/12\/microsoft-dynamics-nav-faster-than-ever\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/no-audience\/2014\/11\/12\/microsoft-dynamics-nav-faster-than-ever\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-content\/uploads\/2014\/11\/1526.plan1_.png","datePublished":"2014-11-12T08:00:00+00:00","dateModified":"2023-05-31T22:46:06+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/no-audience\/2014\/11\/12\/microsoft-dynamics-nav-faster-than-ever\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/no-audience\/2014\/11\/12\/microsoft-dynamics-nav-faster-than-ever\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/no-audience\/2014\/11\/12\/microsoft-dynamics-nav-faster-than-ever\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-content\/uploads\/2014\/11\/1526.plan1_.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-content\/uploads\/2014\/11\/1526.plan1_.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/no-audience\/2014\/11\/12\/microsoft-dynamics-nav-faster-than-ever\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/"},{"@type":"ListItem","position":2,"name":"Microsoft Dynamics NAV: Faster than ever."}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/","name":"Microsoft Dynamics 365 Blog","description":"Modernizing Business Process with Cloud and AI","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/#organization","name":"Dynamics 365 Blog","url":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","width":259,"height":194,"caption":"Dynamics 365 Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/#\/schema\/logo\/image\/"}}]}},"word_count":1498,"msxcm_display_generated_audio":false,"distributor_meta":false,"distributor_terms":false,"distributor_media":false,"distributor_original_site_name":"Microsoft Dynamics 365 Blog","distributor_original_site_url":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-json\/wp\/v2\/posts\/43344","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-json\/wp\/v2\/users\/4544"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-json\/wp\/v2\/comments?post=43344"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-json\/wp\/v2\/posts\/43344\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-json\/wp\/v2\/media?parent=43344"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-json\/wp\/v2\/post_tag?post=43344"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-json\/wp\/v2\/product?post=43344"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-json\/wp\/v2\/content-type?post=43344"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-json\/wp\/v2\/topic?post=43344"},{"taxonomy":"audience-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-json\/wp\/v2\/audience-type?post=43344"},{"taxonomy":"audience","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-json\/wp\/v2\/audience?post=43344"},{"taxonomy":"ms-author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-json\/wp\/v2\/ms-author?post=43344"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-json\/wp\/v2\/coauthors?post=43344"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}