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 updated 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. -- 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/30ea4cd7-0875-436e-af80-4da4109225a7n%40googlegroups.com.
