- Use resources/initDB.sql to create tables;
- Use resources/populateDB.sql to generate 2 million entries and create table c using SQL
[2016-09-26 12:43:39] 74882 row(s) affected in 1m 28s 282ms ms
- Edit Repository to connect to your DB
private static final String LOGIN = "puser";
private static final String PASSWORD = "P@ssw0rd";
private static final String URL = "jdbc:postgresql://localhost:5432/topjava";
- Run Main to create tableC using Java
Table C was created. Size: 74882. Time: 21500 ms