[Koha-bugs] [Bug 31222] DBIC queries for batch mod can be very large

[bugzilla-daemon at bugs.koha-community.org]

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

Nick Clemens <nick at bywatersolutions.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|In Discussion               |Signed Off

--- Comment #11 from Nick Clemens <nick at bywatersolutions.com> ---
(In reply to Jonathan Druart from comment #9)
> Why do we want to reduce mysql query length exactly? You are not supposed to
> have mysql logging in production servers, you will face perf issues (but I
> guess you know that already).

We are logging, we seem to have it setup to avoid performance pitfalls, but
larger queries can start to take up space.

Style wise too I think it reads better, and makes query easier to read in
debug.

It seems IN is more performant as well:
https://mariadb.com/kb/en/in/

-- 
You are receiving this mail because:
You are watching all bug changes.