[rt-devel] postgres query optimising (was: Re: [rt-users] Is this slow? It seems slow.)

[Jesse Vincent]

RT runs on Mysql 3, whichi doesn't support UNION, which is one reason
I'm leery of switching to something that requires a UNION in the middle
of a stable series.


On Wed, Jun 11, 2003 at 05:21:41PM +1000, Jamie Wilkinson wrote:
> This one time, at band camp, Jamie Wilkinson wrote:
> >The tough part for SearchBuilder is to know when to use UNION and when to
> >use OR, it's not going to be easy to know the difference.  The other option
> >is to perform each query through SearchBuilder and merge the results in the
> >RT code, which is a bit of an inelegant solution.  Perhaps giving
> >SearchBuilder hints as to which it should use as part of the function
> >arguments is an option.
> 
> Hold the fucking phone.  I've just modified line 264 of Users_Overlay.pm,
> which hardcodes the OR, into a UNION SELECT and the pages are loading almost
> instantly.  aedist coming soon.
> 
> -- 
> jaq at spacepants.org                           http://spacepants.org/jaq.gpg
> _______________________________________________
> rt-devel mailing list
> rt-devel at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-devel
> 

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