MVCC is still a little experimental, so your mileage may vary.
If you could create a simple test-case, and use the profiler on it
http://www.h2database.com/html/performance.html?highlight=profiler&search=profiler#built_in_profiler
we might be able to help you.
On Wed, Aug 1, 2012 at 9:22 AM, IanP <[email protected]> wrote:
>
> 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.
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
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.
