Re: hibernate insert is keep slowing down

Hi All
    I am keep calling the below function to insert 100,000 rows to database. For the first ten 100,000 rows, it takes around 3 seconds. But it keep slowing down, up to 25 sec per 100,100 rows. May I know why hibernate will slow down?

    private void testH2_hibernate() {
        Session session = HibernateUtil.openSession();
        Transaction tx = session.beginTransaction();
        DeleteDbFiles.execute(new File(".").getAbsolutePath(), "jmpDB", true);
        Date start = new Date();
        for (int x = 0; x < 100000; x++) {
            JmpData jmpData = new JmpData(0, new Date(), 12345, "cheung", 12345, "peter", JmpType.CALL, 12345, 12345, 12345, 12345, 12345, 12345, 12345, 12345, 12345, 12345,
                    12345, 12345, 12345, 12345, 12345, 12345, 12345);
            session.save(jmpData);

        }
        tx.commit();
        session.close();
        Date end = new Date();
        System.out.println("hibernate =" + ((double) end.getTime() - start.getTime()) / 1000 + " sec");
    }