[Rt-devel] Re: SetOwner speed

[Ruslan Zakirov]

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?

>
>
>
> --
> WBR,   Alexey G Misyurenko ( MAG-RIPE | MMAGG-RIPN )
> CTO of Caravan ISP            http://www.caravan.ru
> Phone: +7 095 3632252         Cell:  +7 095 5082794
>
>
> _______________________________________________
> List info: http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-devel
>
> Best Practical is hiring! Come hack Perl for us: http://bestpractical.com/about/jobs.html
>


-- 
Best regards, Ruslan.