Attachment 139122 Details for Bug 31313 – Bug 31313: (QA follow-up) Prefetch checkouts and branches

[patch] Bug 31313: (QA follow-up) Prefetch checkouts and branches

Bug-31313-QA-follow-up-Prefetch-checkouts-and-bran.patch (text/plain), 1.07 KB, created by Nick Clemens (kidclamp) on 2022-08-15 11:48:12 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Nick Clemens (kidclamp)

Created: 2022-08-15 11:48:12 UTC

Size: 1.07 KB

patch

obsolete

>From 0f455991ab872b649376c2d2e57a658fa9768836 Mon Sep 17 00:00:00 2001
>From: Nick Clemens <nick@bywatersolutions.com>
>Date: Mon, 15 Aug 2022 11:34:59 +0000
>Subject: [PATCH] Bug 31313: (QA follow-up) Prefetch checkouts and branches
>
>This prefetches objects we are using in templates to avoid extar DB calls
>
>The branch fetches won't actually be used without the extra patch on 31314 that
>adapts home_branch and holding_branch routines to use result objects
>
>Signed-off-by: Nick Clemens <nick@bywatersolutions.com>
>---
> opac/opac-detail.pl | 3 ++-
> 1 file changed, 2 insertions(+), 1 deletion(-)
>
>diff --git a/opac/opac-detail.pl b/opac/opac-detail.pl
>index 09e85e2613..9e9c0eadb0 100755
>--- a/opac/opac-detail.pl
>+++ b/opac/opac-detail.pl
>@@ -501,7 +501,8 @@ $items = Koha::Items->search_ordered(
>                 $biblio->host_items->get_column('itemnumber')
>             ]
>         }
>-    ]
>+    ],
>+    { prefetch => [ 'issue', 'homebranch', 'holdingbranch' ] }
> )->filter_by_visible_in_opac({ patron => $patron }) unless $specific_item;
> 
> my $dat = &GetBiblioData($biblionumber);
>-- 
>2.30.2

Actions: View | Diff | Splinter Review

Attachments on bug 31313: 138821 | 138822 | 138847 | 138848 | 139119 | 139120 | 139121 | 139122 | 139193 | 139239 | 139693 | 139694 | 139695 | 139761 | 139762 | 139763