https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=43931
Bug ID: 43931
Summary: Suggestions page can be slow to load when many
suggestions from many patrons exist
Initiative type: ---
Sponsorship ---
status:
Product: Koha
Version: Main
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: P5 - low
Component: Acquisitions
Assignee: [email protected]
Reporter: [email protected]
QA Contact: [email protected]
Target Milestone: ---
When loading the suggestions page on systems with many suggestions we have seen
a slowdown, the issue seems to stem from this section:
my @codes_list = map {
{
'code' => $$_{'value'},
'desc' => GetCriteriumDesc( $$_{'value'}, $field ) ||
$$_{'value'},
'selected' => ( $$suggestion_ref{$field} ) ? $$_{'value'} eq
$$suggestion_ref{$field} : 0,
}
} grep { $$_{'value'} } @$values_list;
Specifically when dealing with suggestions.suggestedby
GetCriteriumDesc ends up fetching the patron object for each patron in order to
get their first and last name and map it for display as a fitler.
Either we need to fetch all patrons at once, or we can simply remove this
filter from the page as we can now search suggesters using datatables much
faster
--
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list -- [email protected]
To unsubscribe send an email to [email protected]
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/