> 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 :( -- Agnislav Onufrijchuk PortaOne, Inc., RT Developer Tel: +1-866-SIP VOIP (+1 866 747 8647) ext. 7670 Meet us on April 14-15 at Booth 1202 Billing & OSS World Conference & Expo Rio All-Suite Hotel & Casino, Las Vegas _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com