https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21622

--- Comment #13 from Nick Clemens <[email protected]> ---
(In reply to Jonathan Druart from comment #11)
> (In reply to Nick Clemens from comment #10)
> > I missed this one and filed 22260
> > 
> > I am wondering if one situation is preferable to the other (subquery vs
> > adding all fields to group by)
> > 
> > Bug 20182 and 21723 imply there may be some issues here - can we get some
> > opinions here on the best way to fix these situations?
> 
> Could you benchmark the 2 queries on a big production DB?

~.1 seconds for this solution vs ~4 seconds for the other

Deprecated in favor of this one, we should invesitgate 21723 on its own I think

-- 
You are receiving this mail because:
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[email protected]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

Reply via email to