Clearly not going to get a response here, so I've worked around the problem in my application code. However, for those using mvcc it's worth noting that insert times increase in non-linear manner to quickly become unacceptably slow when using prepared statements to do inserts in very small tables with foreign key references, as per the test case I've provided.
Maybe this is actually expected behaviour for mvcc rather than a bug. If so, it's expected behaviour that is very worth avoiding if you're using H2 in your appliction. Cheers, Ian. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To view this discussion on the web visit https://groups.google.com/d/msg/h2-database/-/4TbumZE3TcoJ. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
