[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:
>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.

Too soon, in fact.  Just found an error with my fix, it changes the subquery
fine but isn't returning the right information back.  I'll have to fiddle a
bit more before I've got a useful speedup.

-- 
jaq at spacepants.org                           http://spacepants.org/jaq.gpg