[Rt-devel] Re: SetOwner Speed

Alexey G Misyurenko mag at caravan.ru
Mon Jun 19 13:25:54 EDT 2006


Alexey G Misyurenko wrote:
>
> Linux, 9.2.0.6
>> When did you last run: ?
>>   
> If be onest I don't know because DBA is unaccesseble right  now.
> So I start next one sql right now, and currently it's run
>
>> BEGIN   SYS.DBMS_STATS.GATHER_SCHEMA_STATS (      OwnName           
>> => 'RT_USER'     ,Granularity       => 'DEFAULT'     
>> ,Options           => 'GATHER'     ,Gather_Temp       => FALSE     
>> ,Method_Opt        => 'FOR ALL INDEXED COLUMNS SIZE 1 '     
>> ,Degree            => 4     ,Cascade           => TRUE     
>> ,No_Invalidate     => FALSE); END;
>>

Request finished but without speedup system %(

I think the problmes is more complex.
For example, wheh I open queue (
http://www.rt.inside.caravan.ru/Search/Results.html?Query=Queue%20=%20'NOC'%20AND%20(Status%20=%20'open'%20OR%20Status%20=%20'new'%20OR%20Status%20=%20'stalled')
)
Ticket list is format quickly.
But when it "published" to the web
/Elements/CollectionAsTable/Row
take from 0.5 to 8 second to generate and output all row.

May bee somethink must be done also to correct upgrade from 3.4.4 to 3.6.0 ?
And is exist diffs from 3.6.0rc3 and 3.6.0 ?



More information about the Rt-devel mailing list