[rt-users] Very slow query in RT 3.4.1

[Marc Prud'hommeaux]

Well, even if I did reduce the amount of spam, that wouldn't help the 
problem at hand, since the 200K+ spam users would still remain in the 
Users, Groups, and Principles tables in the database. To my knowledge, 
it is still impermissible to delete users and groups, correct?


On Apr 5, 2005, at 1:17 PM, rt-users-request at lists.bestpractical.com 
wrote:

> Date: Tue, 5 Apr 2005 15:50:55 -0400
> From: "Jay R. Ashworth" <jra at baylink.com>
> Subject: Re: [rt-users] Very slow query in RT 3.4.1
> To: rt-users at lists.bestpractical.com
> Message-ID: <20050405155055.B15135 at cgi.jachomes.com>
> Content-Type: text/plain; charset=us-ascii
>
> 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
>


--
Marc Prud'hommeaux
SolarMetric Inc.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 2108 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20050405/fd36a3f8/attachment.bin>