H2 benchmarks comparing h2 and derby Using the default settings in the benchmark I get these results:
Testing the performance of H2 H2 1.1.104 (2008-11-28) Loading item table: 10% Loading item table: 0% Statements per second: 31327 Testing the performance of Derby Apache Derby 10.4.2.0 - (689064) Loading item table: 10% Loading item table: 0% Loading stock table (warehouse 1): 37% Statements per second: 7233 I changed the configuration to the following: - Both use 4m caches (4 megs, default derby cache size) - Both use index logging (derby's default, can't be turned off so I changed h2 to do index logging) - Both are not using durable operations (h2's normal operation, option in derby) Note: There is no write delay setting for derby so h2 still has an advantage. db1 = H2, org.h2.Driver, jdbc:h2:data/ test;LOCK_TIMEOUT=10000;LOCK_MODE=3;LOG=2;CACHE_SIZE=4096, sa, sa Adding -Dderby.system.durability=test to the command line for the test turns off derby's durability The results are: Testing the performance of H2 H2 1.1.104 (2008-11-28) Loading item table: 10% Loading item table: 0% Loading stock table (warehouse 1): 14% Statements per second: 5722 Testing the performance of Derby Apache Derby 10.4.2.0 - (689064) Loading item table: 10% Loading item table: 0% Loading stock table (warehouse 1): 56% Statements per second: 12501 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/h2-database?hl=en -~----------~----~----~----~------~----~------~--~---
