public class MariaDBTest {
    
    private static final int nEvents = 1000;
    
    private static final String url 
            = "jdbc:mariadb://192.168.0.158:3306/scjms_db";
    private static final String driver = "org.mariadb.jdbc.Driver";
    private static final String user = "root";
    private static final String password = "root";
    private static Connection connection = null;
    private static Statement statement = null;
    
    public static void main(String[] args) 
            throws SQLException, ClassNotFoundException {
        Class.forName(driver);
        connection = DriverManager.getConnection(
                url, user, password);
        statement = connection.createStatement();
        
        String sqlQuery = "insert into event_entity () values ()";
        
        long start = System.currentTimeMillis();
        for (int i = 0; i < nEvents; i++) {
            statement.execute(sqlQuery);
        }
        System.out.println("Saving of " + nEvents + " events takes " 
                        + (System.currentTimeMillis() - start));      
        
        statement.close();
        connection.close();
    }

}

CREATE TABLE t1 (c1 INT);

DELIMITER // 
CREATE PROCEDURE t1insert2 () begin
DECLARE i INT DEFAULT 1; 
WHILE i<1001 DO
INSERT INTO scjms_db.t1 (c1) Values (i);
SET i=i+1; 
END WHILE;
end //
CALL myinsert();

// Which engine ?
 create table scjms_db.t1 … 


DELIMITER // 
CREATE PROCEDURE t1insert2 () begin
DECLARE i INT DEFAULT 1; 
 START TRANSACTION;
WHILE i<1001 DO
 INSERT INTO scjms_db.t1 (c1) Values (i);
SET i=i+1; 
END WHILE;
 COMMIT;
end //
CALL myinsert();