Hi, I have an embedded database that's quite big (300MB) which I access using Hibernate / EntityManager to execute a native SQL query. With an XMX value of 945M a certain query takes about 3 seconds. With an XMX value of 940M (just 5MB less) the query takes extremely long (more than 240 seconds).
Here are screenshots of JVisualVM of both instances: Screenshot with 945M: https://i.imgur.com/ALCqWLg.png Screenshot with 940M: https://i.imgur.com/rKRnKps.png As you can see in neither case the max memory is actually used. Executing the query using the H2 console is fast. How is that possible? Thanks. -- 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.
