[rt-devel] Re: RT SQL 'lockup' (mysql->99% cpu)

Jesse Vincent jesse at bestpractical.com
Tue Jul 22 12:28:35 EDT 2003

On Tue, Jul 22, 2003 at 01:20:08PM +0100, Iain Price wrote:
> PS: I think the issue is the users dont understand the search criteria dont
> reset when you go back to the search page... maybe have two buttons,
> 'search' and 'refine search'?

It used to be that way. It confused users too much.

> dunno, i can see this issue in two lights - a)
> stupid user, who cares, rt does what it does, or b) users can completely
> halt RT functionality which is a disaster - completely opposing views,
> Jesse, which approach do you take for RT - user or admin tool?

I train my users.  If your users have a legitimate need for searching
for tickets with a combination of multiple requestor addresses, it's
probably worth looking at the queries RT's generating and seeing what
can be done indexwise to increase the performance.


http://www.bestpractical.com/rt  -- Trouble Ticketing. Free.

More information about the Rt-devel mailing list