Just how fast is SQL Server and Dynamics NAV vs. MAS 90 or MAS200?

fast There is a lot of discussion back and forth about reporting speeds in business and accounting applications.  I recently did some benchmark testing as shown in this video below to highlight the difference.
MAS90 and MAS200 run on a flat file database.  The way it is written, internal ‘hard coded’ reports run fairly quickly, but reports and external applications that access its data via ODBC (such as Crystal Reports) can be painfully slow.
This issue becomes even more obvious when reports use more than one ‘left outer join’ which means you are matching up data from two places where there isn’t a guarantee data exists to link in both tables.  An example of this is an Invoice History report showing salesperson information from another table but yet MAS 90 doesn’t require a salesperson to be associated with an invoice.

Dynamics NAV (Navision) and many other applications (like SAP Business One) use a high performance relational database like Microsoft SQL Server
Everything about this test is stacked in MAS 90’s favor.  The MAS 90 example was run on a native Core 2 DUO laptop.  The SQL Server example wasted tested on a VMWare virtual machine running on that same laptop.  That means the environment is about 30% slower than the native machine.
Yet the results of the test are staggering.  The SQL version of the report runs in an order of magnitude faster.
Take a look here:

2019-01-16T11:37:34+00:00 July 18th, 2010|Dynamics 365 Business Central (Dynamics NAV)|Comments Off on Just how fast is SQL Server and Dynamics NAV vs. MAS 90 or MAS200?