[rt-users] Very slow query in RT 3.4.1

[Jay R. Ashworth]

On Tue, Apr 05, 2005 at 12:07:26PM -0700, Marc Prud'hommeaux wrote:
> That's what I was afraid of. Short up switching from MySQL to  
> PostgreSQL or upgrading to MySQL 4.1, can anyone recommend anything at  
> all that might help with the search? Would trying to trim the size of  
> the Principals or Groups tables help (they have 200,000+ rows in each,  
> due primarily to the large amount of spam we receive via support)?

With all due respect, please allow me to suggest that your best
investment of time and effort may be to go hard-core on despamming
those mailboxes...?

Cheers,
-- jra
-- 
Jay R. Ashworth                                                jra at baylink.com
Designer                          Baylink                             RFC 2100
Ashworth & Associates        The Things I Think                        '87 e24
St Petersburg FL USA      http://baylink.pitas.com             +1 727 647 1274

      If you can read this... thank a system administrator.  Or two.  --me