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

[Jamie Wilkinson]

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