[rt-users] MyRequests apparent bug

[Jesse Vincent]

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.