[Koha-bugs] [Bug 8329] GetLostItems in C4::Items.pm has a SELECT *

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8329

--- Comment #1 from M. Tompsett <mtompset at hotmail.com> ---
Created attachment 10565
  -->
http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=10565&action=edit
Reduced memory requirements of a massive select statement

SELECT * joining items, bibioitems, and biblio is bad. The MARC and XML fields
will eat memory very quickly. Our server has ridiculously low memory and lots
of items marked as lost. We were getting Error 500 pages as output as a result.

Since the GetLostItems function is only used by the Items Lost report, I looked
at the template in reports/itemslost.tt to get an idea of what might better be
suited in the SELECT statement.

It was horribly slow, but finally worked. I need to get more than 512MB for our
server.

-- 
You are receiving this mail because:
You are watching all bug changes.