https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14598
--- Comment #141 from Gwendal JONCOUR <[email protected]> --- 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. _______________________________________________ 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/
