TFB Round bebca46e-899f-4958-8052-d5f5f5c81eb2

[greenlaw110]

https://tfb-status.techempower.com/results/bebca46e-899f-4958-8052-d5f5f5c81eb2

Changes

Change 1

• hibernate_pgsql - db.maxConnections changed from 20 to 10

Change 2

• ebean datasource pool changed from HikariCP to druid
• eclipselink datasource pool changed from internal to HikariCP

Results

hibernate-pgsql

Updates

• from 676 to 1222

Conclusion: positive, can try reduce DB connection from 10 to 5 for next time

Ebean

Single Query

Multiple Queries

Fortunes

Updates

Conclusion:

1. Single query and multiple queries shows big drop in throughput
2. Fortunes test shows great improvement - clearly shows something wrong with ebean/hikaricp/rythm combination
3. Updates test shows improvements in mysql but drop in pgsql.

Eclipselink

Single Query

Multiple Queries

Fortunes

Updates

Conclusions

1. There are clear sign shows pgsql read performance is improved a lot while mysql read performance has slightly drop
2. updates performance has significant drop on both pgsql and mysql

Plan for next round

1. [hibernate_pgsql] keep reduce max connections for updates down to 5
2. [ebean]
   • try switch to ebean internal datasource pool
   • reduce max connection for updates
3. [eclipselink]
   • try tune max connection for mysql read
   • reduce max connection for updates