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/12f6ea81-c268-4ac1-ba45-6f46b1cc2077n%40googlegroups.com.
