https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=43787 Bug ID: 43787 Summary: Adding orders from a staged file ( addorderiso2709.pl ) can use gigabytes of memory if there are many funds Initiative type: --- Sponsorship --- status: Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: Acquisitions Assignee: koha-bugs@lists.koha-community.org Reporter: kyle@bywatersolutions.com QA Contact: testopia@bugs.koha-community.org Target Milestone: --- The page for adding orders to a basket from a staged file has a fund dropdown for each record, and another for each item when MarcItemFieldsToOrder is used. Each dropdown lists every fund from every budget, inactive ones included, and the template loops that build them are so deeply indented that most of the page is whitespace. With about 1,000 funds ( not difficult for a large system that rolls over funds anually ) and a staged file of 140 records and 287 items, the page is 367 MB, 88% of it whitespace, and the Plack worker that renders it peaks at 4.5 GB of memory. To recreate: 1) Create 1,000 funds in an inactive budget 2) Set MarcItemFieldsToOrder to: homebranch: 952$a holdingbranch: 952$b itype: 952$y 3) Stage a file of 140 records with items from Add to basket > From a new file 4) Click "Add staged files to basket" 5) Note the size of the page and the memory used by the Plack worker -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.