I'm using the latest version of H2. I have a table named STR with 4 columns: AUTO_ID integer (pk) STR_VALUE varchar(100) STR_COUNT double STR_WEIGHT double
I have all of the columns populated except for the STR_WEIGHT column. If I run the following update query to calculate the weight: UPDATE STR SET STR_WEIGHT = STR_COUNT / 5.7 ... the update statement takes 10+ seconds on a table with ~100k rows and even longer on larger tables. I don't get why this is so slow. It should just quickly scan all of the rows and update the weight column. No index should (to my knowledge) be required. I have an index on the STR_VALUE column, but I don't see why that would matter in this instance. -- 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/a60b94c7-0678-497c-bf79-6bacecbfb2a7n%40googlegroups.com.
