[rt-users] Very slow query in RT 3.4.1

Les Mikesell les at futuresource.com
Wed Apr 6 11:40:30 EDT 2005


On Tue, 2005-04-05 at 14:50, Jay R. Ashworth wrote:
> 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...?

It's a generic problem for anyone supporting a public site where even
if you can filter the spam you end up with many thousands of users
created from email addresses who typically only ask one question.

-- 
  Les Mikesell
   les at futuresource.com





More information about the rt-users mailing list