Hello, On Thu, Apr 29, 2010 at 8:35 PM, Justin Hayes <[email protected]> wrote: > Hi Ruslan, > > I have both of those indexes already, and in SelfService I have no control > over the query being run - it's just trying to show the 'My open tickets' > panel.
My open tickets panel uses user's ID as far as I know and it's even faster. Optimize/Analyze on tables sometimes help convince optimizer, but anyway read below. > Also there is no problem with SelfService with a privileged account that has > rights to see queues/tickets, so it seems to be something else that's the > problem. Something rights related? Then next step is to look into log of slow queries and figure out what query is so slow that user waits forever. > Thanks, > > Justin -- Best regards, Ruslan. Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
