https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31856
--- Comment #52 from David Gustafsson <[email protected]> --- Some comments about the flame graphs. An empty search was performed on 164 subscriptions, (in production we have many more, but search results are limited to 1000). In the "With object caching" flame graph (a version of with only the object caching), Koha::Template::Plugin::AuthorisedValues->get_by_code went from 1150ms to 30ms, and Koha::Template::Plugin::AuthorisedValues->GetDescriptionByKohaField from 466ms to 269. I think those to cover most of the speedups. In the "With object caching" in addition to the above, Koha::Object::Mixin::AdditionalField->get_additional_field_values_for_template, which took 3900 ms, was replaced with one query to fetch the fields of all subscription results at once, which took about 25ms. Without the patch think there is more or less a linear relationship between execution time and the number of serials, so while around 100 or so is still pretty slow, it gets almost unusable with say a thousand (even though it's not a practical amount of search results, it's still frustrating for librarians to have to wait for a response if accidentally did an empty search, or a search that produced many hits. -- 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/
