Hi, > The above query took more than 1 sec per row update.
Does the update statement use an index? To find out, use EXPLAIN UPDATE ... > I would like to know why the updating the table with 3k rows taking longer > time when concurrent read requests are there? > Is there any configuration settings I can use to optimize this? Is the update performance OK if there are no queries running? Maybe artificially slowing down the queries would help (but probably only when using MVCC). To do that, you need to use a separate connection to run the queries, with the 'throttle' option: http://h2database.com/html/grammar.html#set_throttle Regards, Thomas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
