[Koha-bugs] [Bug 14598] itemtype is not set on statistics by C4::Circulation:: AddReturn

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Tue Apr 25 16:09:09 CEST 2017


https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14598

--- Comment #141 from Gwendal JONCOUR <gwendal.joncour at univ-rennes2.fr> ---
Created attachment 62682
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=62682&action=edit
Set itemtype on stats - Rennes 2 version

Well... I start to run your script on our database and when I checked the mysql
queries called in the loop, I saw they took 70s each to be executed.
Extrapolating from that, the 300k loops will take a little more than eight
months to run. It will be a pretty long downtime for a production update :-\

I make my own version of this update function looping on itemtype and call
serately items tables and biblioitems tables. On our database, it took 1h20m to
update (for info, we have "item-level_itypes" parameter on so the script rarely
call the biblioitem query).

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


More information about the Koha-bugs mailing list