Hi Folks,
I was wondering if anyone has tried to use H2 database and done any performance tuning. We are trying to use H2 database engine for our application. However I am experiencing lot of performance issues. For example H2 is taking 18 seconds to run a simple query where I am joining two tables with 220K and 170K rows respectively. A same query on same tables and same data on sql server takes fraction of second to run. Even queries on de-normalized(flattened) table without doing any joins run equally slower. Something must be fundamentally wrong her but not yet able to figure out root cause of the issue. Hence reaching out to the community... I have made sure that - we use H2 in in-memory/multithreaded mode (jdbc.url=jdbc:h2:mem;CACHE_SIZE=3072000;MULTI_THREADED=1;LOCK_MODE=3) - table join is done on integer columns - proper indexes are created and are used by optimizer - cache size is defined big enough (3+GB) - I have enough RAM(16GB) - I refresh the index statistics any help will be highly appreciated.. Thanks vinay -- 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.
