On 2013-08-12 15:26, Pierre wrote:
this last bench was Inserting 500000 t1 records and 3000000 t2 records
MySQLDB...
~7573 i/s 0:06:36.124 (396124 ms)
Close 0:00:00.001 (1 ms)
HSQLDB...
~4853 i/s 0:10:18.080 (618080 ms)
Close 0:00:00.005 (5 ms)
H2DB...
~1874 i/s 0:26:40.641 (1600641 ms)
Close 0:00:08.438 (8438 ms)
Something is weird there, because I'm not getting quite the same
results. Could have something do with Windows vs Linux.
I'm running an extra step called H2DB_NoLog where I turn off all our
normal safety stuff using "LOG=0;UNDO_LOG=0;LOCK_MODE=0"
And I get:
Inserting 200000 t1 records and 1200000 t2 records
---
H2DB... 77922 ms
HSQLDB... 74271 ms
H2DB_NoLog... 33908 ms
---
H2DB... 70538 ms
HSQLDB... 110464 ms
H2DB_NoLog... 34432 ms
---
H2DB... 70859 ms
HSQLDB... 151595 ms
H2DB_NoLog... 34266 m
If I switch to using PreparedStatements instead of Statement, I get this:
Inserting 200000 t1 records and 1200000 t2 records
---
H2DB... 55788 ms
HSQLDB... 44003 ms
H2DB_NoLog... 9959 ms
---
H2DB... 50332 ms
HSQLDB... 80267 ms
H2DB_NoLog... 10555 ms
And I can't even run larger tests with HSQLDB because it just uses up
all of the memory and makes the VM crash.
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/groups/opt_out.
