search

zloster / FrameworkBenchmarks

Source code for the framework benchmarking project
http://www.techempower.com/benchmarks/
Other
0 stars 0 forks source link

Check if there is actual difference in the performance if the DB connection pool is using the recommended DB driver class #43

Closed zloster closed 6 years ago

zloster commented 6 years ago

the recommended DB driver class or maybe it will help with the transaction deadlocks? Ordering of the updates should help with the transaction deadlocks. (https://gist.github.com/isopov/9af3864888b85c6cffc4 and some comments in the TFB issues/PRs). Also the Resin documentation strongly recommends usage of the JDBC more advanced connection options if available. The Driver class is a last resort.

Also check the setting of the PostgreSQL about the server-side prepared statement threshold.

zloster commented 6 years ago

Also the Resin documentation: http://caucho.com/resin-4.0/admin/database.xtp#JDBC2.0-ConnectionPoolDataSource

zloster commented 6 years ago

52805 vs 56594 RPS for the DB test. Submitting a PR with only changed the datasource. The prepared statement threshold is not very helpful for the benchmarks because the very small number of different statements is used - after the warm up and the various test cases we should see statement reuse. PR is 3365.