Thomas,
> Does the update statement use an index? To find out, use EXPLAIN UPDATE ... Yes it uses. > Is the update performance OK if there are no queries running? Yes if there are no or few queries then the update performance is good. Thanks, Suresh On Thu, Mar 3, 2011 at 1:02 AM, Thomas Mueller <[email protected] > wrote: > 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. > > -- 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.
