[rt-devel] Performance concerns

[Jesse]

On Tue, May 08, 2001 at 03:58:28PM +1000, Byron Ellacott wrote:
> Attached is a log from MySQL of the queries issued when I log into an
> RT2 system populated with around 80,000 tickets (our current RT1 load).
> 
> If you look at the timestamps, you'll see it's taking about 2 minutes to
> issue them all. 

That's no good. I definitely wanna take a look at that. And I may have
something of a magic bullet up my sleeve ...


> This is a pretty long wait to log into the system, and
> other operations also seem to be fairly slow.  Is this a problem
> specific to my installations, or have other people been noticing long
> delays?

I suspect that the mail gateway software either lopped off your attachment or 
would reject it based on message size. Wanna put it somewhere online
that people can reference by URL? (Or bounce it to me and I can do that)

        -j



> And welcome back Jesse, hope you had a good holiday :)

Yep. Definitely. Thanks.

> 
> --
> bje
> 
> _______________________________________________
> Rt-devel mailing list
> Rt-devel at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-devel
> 

-- 
jesse reed vincent -- root at eruditorum.org -- jesse at fsck.com 
70EBAC90: 2A07 FC22 7DB4 42C1 9D71 0108 41A3 3FB3 70EB AC90

There are no supercomputer applications that are solvable that cannot be solved
in finite time using a fucking TRS-80 with approprite disk/tape drives.  Zero.
									-Tanj