The intention of this project is to compare performance of INSERT statement on PostgreSQL and MySQL. It inserts data in batches to both databases.
Duration on Postgres: approx. 18s
Durationn on MySQL: approx. 1s
The question is: why does it take so long on Postgres?
The solution can be found at StackOverflow - http://stackoverflow.com/questions/37942063/slow-insert-on-postgresql-using-jdbc
How to build:
- Create database "postgres-vs-mysql" in both PosqtgreSQL and MySQL servers
- Create a table "u_test_change_request" in both databases. You can find the scripts in "src/main/resources"
- Run "mvn package"
- Run LetsGo class.