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/

Reply via email to