I also checked for disk activity - it varies throughout the duration of the runtime, but there are wide windows where the disk is quite idle and the H2 still works slowly - 15 seconds for a query that usually takes 400ms.
On Saturday, April 29, 2017 at 11:37:46 PM UTC+3, Avi Shefi wrote: > > The DB URL is like this: > jdbc:h2:tcp://localhost:<port>/<path-to-db-file>;USER=<user>;PASSWORD=<password>;... > > Basically I have two Maven modules that each create their own independent > H2 in embedded mode. There is no interaction between the modules, each one > spins-up a H2 embedded database referring to a file on disk, does its own > thing and in the end it closes the database. There are no leftover H2 DBs > running once each module finishes its work. Other than that all the other > modules do not use H2 in any way. > > Regarding the tests - no, see my previous paragraph. In fact, these are > not tests, rather kind of a load & query that is used for generating some > build-time related artifacts. > > Regarding contention - the module that uses H2 is the only one that is > accessing it, and is the only one querying the database at that time. When > I execute it alone, As described in my initial post: normally it takes 2-3 > minutes. Together with other unrelated modules in parallel - ~1 hour. > > > > On Saturday, April 29, 2017 at 2:21:50 PM UTC+3, Noel Grandin wrote: >> >> Another thing: are all your tests perhaps sharing the same db? >> Could be this is just contention on one table. >> On Sat, 29 Apr 2017 at 07:29, Noel Grandin <[email protected]> wrote: >> >>> shouldnt be, but h2 has lots of features and options, could be an >>> unexpected interaction >>> >>> On 28 April 2017 at 22:57, Silvio <[email protected]> wrote: >>> >>>> Why do you ask that? Is multiple dbs inside one jvm a possible reason >>>> for poor performance? If that is the case we are in serious trouble... >>>> >>>> -- >>>> 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. >>>> >>> >>> -- 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.
