https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31856
--- Comment #48 from David Gustafsson <[email protected]> --- I think it was a mistake to rename the bug and break out the optimized fetching of additional fields. I wrote an earlier comment that it was not needed if an index was added for record_id in the additional_field_values table. But trying that now actually resulted in a significant slowdown, so while a little bit confused about how I came to that earlier conclusion it actually seems like this change is needed, as get_additional_field_values_for_template seems like the main culprit with regards to the slow serial search performance. It performs one query per subscription, and also bypasses the cache as searches performed on an existing resultset are excluded from cache. I will attach screenshots with profiles before and after the change. -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list [email protected] https://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/
