https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=44093 Bug ID: 44093 Summary: Notices management: avoid rendering hidden frame and queries for every listed notice Initiative type: --- Sponsorship --- status: Product: Koha Version: Main Hardware: All OS: All Status: NEW Severity: minor Priority: P5 - low Component: Notices Assignee: koha-bugs@lists.koha-community.org Reporter: martin.renvoize@openfifth.co.uk QA Contact: testopia@bugs.koha-community.org CC: martin.renvoize@openfifth.co.uk Depends on: 33260 Target Milestone: --- Follow-up to bug 33260, reported by Pedro Amorim. Notices management does potentially heavy work for every listed notice on each load. Each listed notice renders a hidden frame with its full content, and runs its own queries for its patron and its notice template. With up to 1000 notices listed, that is up to 1000 hidden frames and over a thousand extra queries per page load. The content, patron and template lookups should be done lazily (only when a notice is previewed) or prefetched in bulk. Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33260 [Bug 33260] Show message queue on staff interface and make notices printable -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.