https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33627
--- Comment #1 from David Cook <[email protected]> --- My frustration around speed/memory use are what caused me to write the patch for bug 37486 But even then... it's still very slow and memory hungry. At a glance, we're fetching the entire database of metadata (deleted and active records) into an array instead of using an iterator, and the only reason we're doing that is do get a count of the array entries. An easy first step optimization would be to first do a count() query and then do the query itself. Database level caching should make that reasonably quick. That should improve memory usage, although I don't know about speed. In theory, that might actually be slower since it'll have to fetch the records one by one from the database result set. Although it might be faster since it won't have to spend time sitting trying to allocate a big enough chunk of memory to manage everything. Time will tell about time I guess. -- Anyway, just a thought for first steps. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes. _______________________________________________ Koha-bugs mailing list [email protected] https://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/
