From c8f2092ebe4f93f56897738c9010114ad42fe77e Mon Sep 17 00:00:00 2001 From: Michael Hafen Date: Tue, 9 Sep 2008 14:33:32 -0600 Subject: [PATCH] Don't pull all of biblioitems in GetItemsInfo Pulling marc and marcxml for some 1200 copies takes a lot of RAM. Lets not do that. Signed-off-by: Galen Charlton --- C4/Items.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/C4/Items.pm b/C4/Items.pm index dd78f98693..1f92491a93 100644 --- a/C4/Items.pm +++ b/C4/Items.pm @@ -1184,7 +1184,7 @@ If this is set, it is set to C. sub GetItemsInfo { my ( $biblionumber, $type ) = @_; my $dbh = C4::Context->dbh; - my $query = "SELECT *,items.notforloan as itemnotforloan + my $query = "SELECT items.*,biblio.*,biblioitems.volume,biblioitems.number,biblioitems.itemtype,biblioitems.isbn,biblioitems.issn,biblioitems.publicationyear,biblioitems.publishercode,biblioitems.volumedate,biblioitems.volumedesc,biblioitems.lccn,biblioitems.url,items.notforloan as itemnotforloan FROM items LEFT JOIN biblio ON biblio.biblionumber = items.biblionumber LEFT JOIN biblioitems ON biblioitems.biblioitemnumber = items.biblioitemnumber"; -- 2.20.1