[rt-users] Really slow Search page startup suddenly

[Jesse Vincent]

On Apr 6, 2007, at 10:14 AM, Philip Kime wrote:

> Hmm - not that I know of - we don't have that many users, even if  
> they could all own tickets, it would be about 1300 users. Is that  
> large enough to be a problem? Normally the Owner list is less than  
> 100 users so I could check if someone did something. It seems back  
> to normal now though ...

That was 288 users for the list, so maybe.

>
> I noticed that the DB query was in the state "Copying to tmp table"  
> for most of the time the query took.

That might indicate that your db wants a bit of tuning.

-j

> PK
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20070406/23b25ad6/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: PGP.sig
Type: application/pgp-signature
Size: 186 bytes
Desc: This is a digitally signed message part
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20070406/23b25ad6/attachment.sig>