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 _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [email protected] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
