Machine has plenty of RAM & CPU - the entire build & related processes consume ~20% of the machine's resources during execution. I have profiled the execution with the CPU profiler, seems like most of the H2-related time is spent on performing the actual queries.
For example, a query which normally takes ~400ms when executed without the other processes takes ~15 seconds when executed with the other processes. It seems like H2's embedded mode is 'shrinking' its performance capacity when it has other neighbors inside the same JVM. I tried playing with CACHE_SIZE and CACHE_TYPE but that didn't help. Any other ideas? On Thursday, April 27, 2017 at 5:30:33 PM UTC+3, Noel Grandin wrote: > > and your machine is definitely not maxing out it's CPU or it's disk IO > bandwidth ? > > If you're sure about, you could try using the JVisualVM CPU profiler (seem > you seem to be familiar with that tool already). > > It produces some nice graphs and visualisations. > -- 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 https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
