Greetings!
1) your write "embedded" mode, but your URL shows File access (not
Memory)
2) you don't state the H2 version you are using
3) maybe provide a simplified, self containing test for people to look
at the details
In general, large DML on indexed columns/tables can lead to "write
amplification". I filed a similar issue 2 years back.
The received advice was:
1) remove indexes, update, create indexes (effective, but not nice)
2) update smaller portions (is this what you mean with "split" mode?)
Best regards
Andreas
On Wed, 2023-07-19 at 07:24 -0700, Andrii Odnoviunenko wrote:
> Hello,
>
> We face the following performance issue of the H2 Database V2 in
> the embedded mode is not good
> (UPDATE statement for 1 column in a table with 1 Million dataset
> with a unique index column ) takes about 40 seconds
>
> jdbc:h2:file:XX:CACHE_SIZE=600;QUERY_CACHE_SIZE=16;
>
> also "merge into" statements with a join between 2 indexed columns
> are comparably slow.
> In general the performance is times worse than in a test with Oracle
> database
>
> various settings have been tried (increasing cache size helped a bit,
> but not much
> I have also tried the "split" mode and changing page size to other
> values (there have ben only marginally small performance gains)
>
> Please advice what the reason can be? Which other settings may cause
> this performance issue?
> --
> 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 h2-database+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/h2-database/d5484788-daed-48e8-9ca1-3369e11f3350n%40googlegroups.com
> .
--
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 h2-database+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/h2-database/b12c2d76f3610a24e287bae00dc9c024c4a19317.camel%40manticore-projects.com.