Improve Synchronous Performance

[caleblloyd]

With the merging of #58, Async Performance is solid. Threads are not held and Performance tests can run 500+ RPS while keeping response time under 1s.

There is problems with threads getting held during Synchronous performance tests, however. Synchronous tests have trouble achieving 100 RPS without lockups.

While it is best practice to use Async methods, we can't guarantee that everyone is doing that. Need to investigate synchronous performance issues and improve so that there are no lockups.

[caleblloyd]

Fix will come once https://github.com/bgrainger/MySqlConnector/issues/62 is merged into MySqlConnector and released

[yukozh]

Released 10012

[caleblloyd]

Need to change our synchronous methods to call synchronous methods in MySqlConnector. I will work on this tonight.

[caleblloyd]

Quick performance test:

1.0.0: Asynchronous: 30 RPS, Synchronous: 30 RPS
1.0.1: Asynchronous: 300 RPS, Synchronous: still needs fixes

1.0.1 should bring a 10x performance increase

[yukozh]

What is the official perf test result?

[caleblloyd]

What is the official perf test result?

Hardware Setup: Intel i5-6600K (4 cores), Ubuntu 16.04

Test Methodology: Run the performance test for 5s with varying RPS rates until 99th percentile request is within 10% of 100ms. Run at least 3 times.

Results:

Version   IO Type    Sustained RPS @100ms
1.0.0     Async      60
1.0.1     Async      480  => 8x Speedup for Async

1.0.0     Sync       50
1.0.1     Sync       90   => 1.8x Speedup for Sync

These test results also go to show how important it is for apps to implement Async all the way down.

Great job @bgrainger on the truly async MySqlConnector and @kagamine on the solid EF implementation. We've got the world's first truly async MySql driver for Entity Framework!

[yukozh]

Could you compare our lib to the oracle one?

[caleblloyd]

Could you compare our lib to the oracle one?

I've got an environemnt variable built into the performance test that will run it with Oracle: export EF_PROVIDER=oracle

The problem is that MySql.Data.EntityFrameworkCore/7.0.5-IR21 has too many bugs and throws exceptions for all of the methods in the performance test. I'll try to run it once they release an update.