Navigate Into Success: Top 5 SQL Server Improvements in NAV 2013

[Blog bot]

[url="http://navigateintosuccess.fortempodoo.netdna-cdn.com/wp-content/uploads/2012/06/image4.png"] with SETAUTOCALCFIELDS

Cust.SETAUTOCALCFIELDS(Balance);

IF Cust.FINDSET THEN

  REPEAT

    // No need for CALCFIELDS, Balance is returned already

  UNTIL Cust.NEXT = 0;



With the option a, whenever you hit the CALCFIELDS, the NST obeys and fetches the sum. With the option b, there is a single SELECT statement, which already includes the OUTER APPLY clause, which calculates the SUM for each row retrieved.

Pretty cool stuff.

4. ADO.NET

The whole shebang is now run on ADO.NET, instead of OLEDB/ODBC that it was before. There are plenty of benefits of that, performance included.

ADO.NET streamlines deployment and administration, increases performance, reduces the number of SQL connections (Jörg has explained some drawbacks of this access, but I think generally that this is a good thing), reduces the memory consumption, and maybe a couple other things.

5. Unicode

I’ve already blogged about this, Jörg has also mentioned this, so I won’t play the same tune yet another time. NAV is now Unicode, which allows you to store characters in any language, at the same time.

Unfortunately, Unicode is not as Unicode as I’d truly love it to be, because the object captions remain tied to the chosen database collation (yes, you still need to choose this). That practically means that while you’ll be able to store characters from any alphabet, your RTC user interface will remain limited to a single character set.

Wrap up

So, to wrap it up, there is a lot of new things, bigger or smaller, that have been changed and that warrant better performance, or user experience, or both.

You may notice that I didn’t mention queries. Yes, they are a mind-boggling improvement over previous versions, but they are simply a completely new feature, not something that NAV had, and now has better than before. My list here is the list of tweaks and tune-ups that take those things that we are used to have to a new level altogether. Queries? Well, they are out of this world, but their true power is yet to come – when (I’m kind of sure it’s about “when”, not “if”) we’ll be able to use them as sources for pages or reports.

Read this post at its original location at http://navigateintosuccess.com/blog/...ts-in-nav-2013, or visit the original blog at http://NavigateIntoSuccess.com. 47fc2f5642456dfd71e5581a3785c625

Читать дальше