[rt-users] MyRequests apparent bug

[Jay R. Ashworth]

On Fri, Mar 04, 2005 at 01:32:32PM -0500, Jesse Vincent wrote:
> On Fri, Mar 04, 2005 at 01:20:23PM -0500, Jay R. Ashworth wrote:
> > On Fri, Mar 04, 2005 at 12:59:52PM -0500, Jesse Vincent wrote:
> > > On Fri, Mar 04, 2005 at 10:05:30AM -0500, Stephen Turner wrote:
> > > > At Friday 3/4/2005 12:12 AM, Rick Measham wrote:
> > > > >MyRequests, MyTickets and I imagine a whole pile of other places in 3.22
> > > > >seem to have a bug ...
> > > > >
> > > > >SO .. it looks like we're getting the top ten, then checking each for
> > > > >permissions rather than checking permissions on all tickets and then
> > > > >showing the top 10.
> > > 
> > > Right. So, asume there are 100,000 tickets in the database. The
> > > performance issue alone makes it a no-go.
> > 
> > How many sites have 100K *non-closed* tickets in their DB?
> 
> 100,000 was a number I pulled out of the air. Even a couple hundred
> tickets would result in an unacceptable performance penalty.
> 
> What I was trying to say is "the solution will be worse than the
> problem." Sites can always change the queries displayed on the frontpage
> to be something that works better locally.

Hmmm... are you not using subselects?  It would seem -- and I haven't
looked at the query -- that if the ACL join was only running on the
subselect, and the subselect wasn't that large, that it wouldn't be a
horrible impact.

You could hack it, too, by limiting the subselect to an arbitrary
number usually high enough to provide the ACL select with 10 results,
assuming that you can do LIMIT on both halves of a subselect.

Assuming it's a subselect at *all*.

But you're right, whether it's worth doing at all is very sensitive to
your ticket universe.  I guess someone for whom it's painful enough
will find a solution.  Isn't open source great?  :-)

Cheers,
-- jra
-- 
Jay R. Ashworth                                                jra at baylink.com
Designer                          Baylink                             RFC 2100
Ashworth & Associates        The Things I Think                        '87 e24
St Petersburg FL USA      http://baylink.pitas.com             +1 727 647 1274

      If you can read this... thank a system adminstrator.  Or two.  --me