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 h2-database+unsubscr...@googlegroups.com. To view this discussion visit https://groups.google.com/d/msgid/h2-database/34a860a8-e295-4d29-b9ee-43761aa32392n%40googlegroups.com.
