[Rt-devel] simple search result count discrepancy
torsten.brumm at kuehne-nagel.com
Tue Aug 15 05:27:28 EDT 2006
have you compare the performance of your query with the original one from
I'm also interesst in this patch to try in our "big" installation.
Mit freundlichen Gruessen / With kindest regards
Kuehne + Nagel
Ferdinand Strasse 29-33
Tel: +49 40 329 15 199
Fax: +49 40 329 15 500
> -----Original Message-----
> From: rt-devel-bounces at lists.bestpractical.com
> [mailto:rt-devel-bounces at lists.bestpractical.com] On Behalf
> Of Roy El-Hames
> Sent: Tuesday, August 15, 2006 11:23 AM
> To: David Smithson
> Cc: rt-devel at lists.bestpractical.com
> Subject: Re: [Rt-devel] simple search result count discrepancy
> I guess the problem here is that Results.html performs 2
> queries, one to count the number of tickets for the search
> and another to fetch the results ..
> I modified my instance of RT to only do one query fetching
> the result and count at the same time, which is more accurate
> and efficient .. not quite sure why it was n't designed to
> do this in the first place, I am sure there was a good reason ..
> David Smithson wrote:
> > Forgive me, I'm a lamer ( old term picked up during Commodore Amiga
> > phase ). What do you mean when you say "performance
> issues"? To me
> > that suggests that there is some variable condition.
> > David Smithson
> > ________________________________
> > -----Original Message-----
> > From: Jesse Vincent [mailto:jesse at bestpractical.com]
> > Sent: Monday, August 14, 2006 10:30 PM
> > To: David Smithson
> > Cc: rt-devel at lists.bestpractical.com
> > Subject: Re: [Rt-devel] simple search result count discrepancy
> > On Mon, Aug 14, 2006 at 10:27:51PM -0700, David Smithson wrote:
> >> Hi. I guess this is sort of a bug, if you happen to use a simple
> > search
> >> in this way:
> >> Where RT has Queues 1-10, and User A owns 371 tickets spread across
> > all
> >> queues, 100 of which are in Queue 1.
> >> * Log in as User B, who has rights to see only Queue 1
> >> * Type 'A' in simple search to find tickets owned by User A
> >> Results header says 'Found 371 tickets', where one might
> expect it to
> >> say 'Found 100 tickets'. The actual results are the 100
> tickets in
> >> Queue 1, which is normal, but the header says differently.
> >> I suppose this might be one of those debatable wishy washy
> >> where a config option might end the debate? Any opinions from the
> >> dev department? Should I submit a bug report? I would
> gladly submit
> >> a patch, but I'm not quite smart enough yet.
> > This comes up every few months. The problem you run into is the
> > horrible, horrible performance issue when checking per-ticket acls.
> > _______________________________________________
> > List info:
> > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-devel
> List info:
More information about the Rt-devel