Toad World® Forums

My SQL TPC-E performance?


I am currently trialing BMF 6.81 (build 545). I am using a TPC-E Transaction Mix test (scale 1), to show the difference of performance against MySQL 5.6 and SQL Server 2012.

Comparing the test results of 50 concurrent users running, MySQL shows a TPS amount of 32, while SQL Server shows a TPS amount of 1138.

This is a big difference. I would expect MySQL to be closer to SQL Server. I must be doing something wrong with MySQL, but both test runs are out of the box.

Any ideas how I can improve MySQL TPC-E score or any config changes I should look at?

Many thanks,