[rt-users] Extremely slow response when adding comment or change people

[Jamie Wilkinson]

This one time, at band camp, Vajkó Péter wrote:
>Jamie Wilkinson wrote:
>>>RT 3.0.2pre3 with postgresql 7.3 is extremely slow at these actions. It 
>>>starts a select like this:
>>
>>
>>>about 150 tickets. I suspect the WhoHaveRigths sub in Users_Overlay.pm.
>>>
>>>Any ideas why this is happening?
>>
>>
>>Not sure, but I found a speed problem with the Instance field of the Group
>>table, it was a varchar(64) but it was storing integers (or null entries)
>>only.
>>
>>I've modified the table, converting instance to integer like so:
>
>It did not help very much. What really helped was the upgrade to the 
>latest SearchBuilder (0.81_04). 0.80 which is required by RT is not able 
>to cope with Postgres.

Yeah, you shuold have tried that in the first place.  The
integer-instead-of-varchar patch helps speed up a different query after the
SearchBuilder upgrade.

-- 
jaq at spacepants.org                           http://spacepants.org/jaq.gpg