[rt-users] What software is recommended for high-loaded RT3.8-latest?

[Kenneth Marshall]

On Thu, Apr 02, 2009 at 05:03:30PM +0300, Agnislav Onufrijchuk wrote:
> > Are these 4000 tickets per day or 4000 updates total? 100000 tickets
> > is not very many if you actually generate 4000 tickets per day. Do
> > you "shred" old tickets to remove them from your DB?
> 
> One more thing: we have 4000 transactions, but we have a number of long SELECT 
> queries every day. No, we didn't shred any of tickets yet, because currently we 
> use 3.4.4 version :(
> 

Have you run EXPLAIN or the MySQL equivalent to see what is taking
the time in the long queries? Maybe adjusting your indexes would
help.

Cheers,
Ken