H2 benchmarks comparing h2 and hsqldb I used the current development 1.9.0 version (svn version 562) so that I don't get the performance penalty for hsqldb cached tables in 1.8.x.
You can get it from here: https://hsqldb.svn.sourceforge.net/svnroot/hsqldb/base/trunk I used H2 1.1.104 (2008-11-28) I ran the benchmark for each database individually because the H2 benchmarks normally run h2 first, then hsqldb but this invalidates the results because the delayed write in h2 causes a performance reduction for the hsqldb benchmark. Setting (h2 default configuration) db1 = H2, org.h2.Driver, jdbc:h2:data/ test;LOCK_TIMEOUT=10000;LOCK_MODE=3, sa, sa 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 Setting (hsqldb default configuration using cached tables) db1 = HSQLDB, org.hsqldb.jdbcDriver, jdbc:hsqldb:data/ test;hsqldb.default_table_type=cached;sql.enforce_size=true, sa Results: Testing the performance of HSQLDB HSQL Database Engine 1.9.0 Loading item table: 10% Loading item table: 0% Loading item table: 95% Statements per second: 29922 Setting (hsqldb using memory tables) db1 = HSQLDB, org.hsqldb.jdbcDriver, jdbc:hsqldb:data/test, sa Results: Testing the performance of HSQLDB HSQL Database Engine 1.9.0 Loading item table: 10% Loading item table: 0% Statements per second: 60367 --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
