What is the best/most time efficient way to insert 1000 rows into one table (jdbc/connector-mysql database)? (it is a buffer and need to be dumped into the database everytime it is full)

1- One auto generated/concanated SQL statement?

2- `for (int i = 0; i<1000; i++) { con.prepareStatement(s.get(i)); } con.commit();`

3- stored procedure ?

4- bulk data insertion via a file?

5- (your solution)