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

--- Comment #1 from M. Tompsett <[email protected]> ---
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.
_______________________________________________
Koha-bugs mailing list
[email protected]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

Reply via email to