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

[Jesse Vincent]

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.

	-jesse
 

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