Is MS SQL Server that much better than MySQL for Acumatica?

MSSQL is generally better choice for Acumatica. It provides better performance for most day-to-day operations as well as for things like upgrade to a newer version. 

However, the difference is usually with 10-20%. There are some special cases where results are significantly worse for MySQL. So, I’d say it depends on your specific load. If that’s a bigger customer where performance is very important and there are a lot of operations running in the background, i’d recommend MSSQL. Otherwise MySQL would do just fine. 

Another point is that some of the customizations are available for MSSQL only. 

@Naveen Boga Understood, but in your consulting experience have you seen MySQL used by a larger customer? Have you had customers switch from one to the other for performance reasons?

In order to understand performance differences between MS SQL and MySQL, I’ve used Maria DB 8.7, and I had a code, which creates 10000 Sales orders.

Code was like that ( sorry for providing pseudo code, I don’t have actual code as of now ):

var graph = PXGraph.CreateInstance<SOOrderEntry>();

for(int i = 0; i < 10 000; i++)

{

      graph.Clear();

       var soOrder = graph.Document.Insert();

       var dtls = graph.Transactions.Insert();

       dtls.InventoryID = some id

       dtls.Qty = some qty

     graph.Transactions.Update(dtls);

}

and then executed it on my laptop on out of the box installation for MariaDB and for MS SQL. Performance difference was on behalf of MS SQL, but can’t tell you exact numbers. Maybe around 10%, but not huge difference. Maybe on next Acumatica virtual dev con will arrange demo to show actual results again.