[Koha-bugs] [Bug 42602] Patron search performance is poor if there are many patrons

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42602 --- Comment #3 from Pedro Amorim <pedro.amorim@openfifth.co.uk> --- Created attachment 199151 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=199151&action=edit Bug 42602: Update datatables library filter column The Datatables column data was set to library.name:me.library_id, causing every library filter to query both fields. This forced a LEFT JOIN on branches even though the filter value is always a branchcode, a column already on the patrons table. Dropping library.name from the data field avoids the JOIN entirely. -- You are receiving this mail because: You are watching all bug changes.