Disabling the foreign key won't work, you need to remove it in order to
get an accurate comparison.
But yeah, MySQL is always going to be faster than us for raw insert
performance.
If you feel happy using MySQL, then use MySQL.
On 2013-08-12 15:20, Pierre wrote:
So I did my test again with your tweaks and disabling foreign key, I
have the same performance issue : more we have rows more H2 is slow.
Starting 500k rows inserted, mysql is more faster for insertion than H2.
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)
--
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.
