Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.java.programmer > #30959

hibernate insert is keep slowing down

Show all headers | View raw

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");
	}

thanks
from Peter (cmk128@hotmail.com)

Back to comp.lang.java.programmer | Previous | Next — Next in thread | Find similar | Unroll thread

Thread

hibernate insert is keep slowing down mcheung63@gmail.com - 2015-01-31 00:11 -0800
  Re: hibernate insert is keep slowing down Arne Vajhøj <arne@vajhoej.dk> - 2015-01-31 19:42 -0500

csiph-web