[Rt-devel] Re: SetOwner speed

[Alexey G Misyurenko]

Ruslan Zakirov wrote:
> On 6/15/06, Alexey G Misyurenko <mag at caravan.ru> wrote:
>> Ruslan Zakirov wrote:
>> > On 6/15/06, Alexey G Misyurenko <mag at caravan.ru> wrote:
>> >> Alexey G Misyurenko wrote:
>> >> > Hello!
>> >> >
>> >> > Tracing why take ticked (from nobody) operation take so long time
>> >> > we found that mostly cost operation is call SetOwner() (from 
>> Take()) .
>> >> > And most cost operation on SetOwner  id
>> >> >
>> >> >
>> >> > my ( $del_id, $del_msg ) =
>> >> > $self->OwnerGroup->MembersObj->First->Delete();
>> >> >
>> >> > Can some body explain for what this is needed?
>> >> >
>> >> >
>> >> And can this call (... First->Delete() ) be omitted when cureent 
>> owner
>> >> is 'Nobody'
>> >> and new owner is not 'Nobody'
>> > no, as nobody is also user :)
>> >
>> Ok.
>>
>> May be is possible to just UPDATE owner of ticked
>> not DELETE and INSTERT?
> No. Can you grab list of queries that RT executes while this operation?
I try and send is as soon as posible.

-- 
WBR,   Alexey G Misyurenko ( MAG-RIPE | MMAGG-RIPN )
CTO of Caravan ISP            http://www.caravan.ru
Phone: +7 095 3632252         Cell:  +7 095 5082794