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 On Friday, March 7, 2025 at 7:13:24 PM UTC-5 Andrei Tokar wrote: > 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 > > On Wednesday, March 5, 2025 at 2:35:29 AM UTC-5 Noel Grandin wrote: > >> try using EXPLAIN PLAN to see what the execution is doing >> >> https://h2database.com/html/performance.html#explain_plan >> > -- 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 view this discussion visit https://groups.google.com/d/msgid/h2-database/34a860a8-e295-4d29-b9ee-43761aa32392n%40googlegroups.com.
