Hi, It's hard to say what the problem might be. I suggest to find out what's going on using the built-in profiler: http://h2database.com/html/performance.html#built_in_profiler
See also the related documentation on that page. Regards, Thomas On Sat, Aug 10, 2013 at 5:37 PM, Pierre <[email protected]> wrote: > Hello, > > I'm running h2 in embedded mode, I have 3 tables, each one having severals > millions of rows. The db file size is ~ 2Go. I'm using only one concurrent > connection to the database. Most of the query are INSERT and MERGE and are > very simple (no join). I have a big Heap size (-Xmx10g). > > Sometime it tooks a very long time to execute the query, more than 15 > seconds. The problem is it doesn't affect a specific query it affects all > the queries. > > So approximatly, every 30 seconds a random query will take more than 15 > seconds to execute instead of some milliseconds. And it will lock all my > application because I synchronize on application level (only one connection > to the DB). Beside, more the DB is growing, more this random slow query is > long (it was 13 seconds at the beginning, now 18 seconds). > > Do you have any idea what could be the reason of this ? Does H2 in > embedded mode can handle DB with severals million of rows ? Any tweaks ? > > -- > 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. > > > -- 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.
