On Tue, Nov 27, 2007 at 08:36:42AM -0800, Gordon Messmer wrote: > Kenneth Marshall wrote: >> Here is our instance data, not slow at all: > > I'm willing to consider that I'm looking in the wrong place... When you > open a ticket, what's the "time to display" on your instance? Which DB are > you using, and what tuning did you do to it? > Gordon,
The time to open and display a ticket varies based on the number of transactions involved, but typically takes on the order of 1-3s. A new ticket with a few updates will take about 1s and an older ticket with many updates takes 3-4s. We are using PostgreSQL 8.2 for the backend DB with the index patches from the mailing list posting. I did have to watch the logs for slow queries, to figure out where indexes were needed. That and keeping the session table cleaned is pretty much all that we need to do. From your description, it sounds like you are just missing an index or two. Once you find out what you need and add them, you will be fine. I can help with PostgreSQL but I do not have much experience with tuning MySQL. Regards, Ken _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users SAVE THOUSANDS OF DOLLARS ON RT SUPPORT: If you sign up for a new RT support contract before December 31, we'll take up to 20 percent off the price. This sale won't last long, so get in touch today. Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745. 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