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