Re: [h2] Extremely slow update performance

[Noel Grandin]

try using EXPLAIN PLAN to see what the execution is doing

https://h2database.com/html/performance.html#explain_plan

[Andrei Tokar]

Generally, it is not a good idea to update 100,000+ rows in a single transaction. Try split it into some batches, lets say of 1,000 or 10,000 rows each

[who...@gmail.com]

Thanks for the tips.  I did try limiting it to fewer rows.

I didn't mean to delete the OP, I meant to forward it to someone else.

If someone else sees this question, the content of the first post talked about an update query that involved a single table, where the value stored in a weight column was updated based on the value in a count column divided by some constant.

E.g.:  UPDATE SCORES SET WEIGHT = CNT / 5.7