[Devel] [Engine-devel] vds_dynamic refactor

[Liran Zelkha]

On Sun, Apr 6, 2014 at 11:22 AM, Itamar Heim <iheim at redhat.com> wrote:

> On 04/03/2014 07:51 PM, Liran Zelkha wrote:
>
>> The problem is with both updates and selects.
>> For selects - to get all the information for the VDS we have multiple
>> joins. Adding another one will hurt performance even more.
>> For updates - we have vds_static thats hardly changed. vds_statistics
>> that changes all the time. vds_dynamic is not changed allot - but is
>> updated all the time because of the status. I think it's best to split
>> it to the two existing tables (BTW - relevant for VM as well)
>>
>
> but we don't update it unless the status has changed, which is a rare
> occurance?
>
Actually - no. We can definitely see times we are updating vds_dynamic with
no reason at all. I tried to create patches for that - but it happens from
many different places in the code.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/devel/attachments/20140406/a8321213/attachment-0001.html>