[rt-users] Very slow query in RT 3.4.1

[Jay R. Ashworth]

On Tue, Apr 05, 2005 at 04:45:44PM -0400, Stephen Turner wrote:
> At Tuesday 4/5/2005 04:39 PM, Jay R. Ashworth wrote:
> >On Tue, Apr 05, 2005 at 01:34:21PM -0700, Marc Prud'hommeaux wrote:
> > > 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?
> >
> >I should think that DELETE CASCADE would be acceptable for users
> >created from spam.  Jesse?  Russ?  Steve?
> 
> I don't know if you mean this Steve, but anyway, I'd be *very* nervous 
> about deleting anything using SQL statements.

I did, in fact, mean you (though I wasn't sure if I'd remembered your
name correctly).

Hmmm...  there has to be *some* reasonable way to clean up the results
of that particular problem...

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