[rt-devel] Another slow MySQL query...

Matthew Watson mwatson at netspace.net.au
Tue Jul 15 04:52:24 EDT 2003


--On Friday, 27 June 2003 12:15 PM +0200 Harald Wagener 
<hwagener at hamburg.fcb.com> wrote:
> With rt 3.0.3 and MySQL 4.0.13, the query below runs for more than 10
> minutes without returning. It is done when searching for more than one
> requestor email address.
>
> Anybody share some insight as how to speed this up?

Yep I hit this problem in the RT 2.0.x series, got around it by making it 
so staff can ONLY search on one requestor at a time.

Can't give you a patch against RT 3.x.x unforunately.

Regards
Matthew Watson
Netspace Online Systems
PH: (03)98110010



More information about the Rt-devel mailing list