Thomas,
Can I create separate data base for each table? The tables are not
related to each other.
Can this help?
Thanks,
Suresh
On Fri, Mar 4, 2011 at 5:39 PM, suresh kumar <[email protected]> wrote:
> 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.
