https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29134
--- Comment #10 from David Nind <[email protected]> --- (In reply to Nick Clemens from comment #6) > (In reply to David Nind from comment #5) .. > That was a typo, it should be:" > INSERT into borrowers(surname, firstname, branchcode, categorycode) SELECT > surname, firstname, branchcode, categorycode FROM ( SELECT surname FROM > borrowers ORDER BY rand() ) a,( SELECT firstname FROM borrowers ORDER BY > rand() ) b,( SELECT branchcode FROM borrowers ORDER BY rand() ) c,( SELECT > categorycode FROM borrowers ORDER BY rand() ) d LIMIT 50000 Thanks Nick - now works as expected, and was able to test. Before patch applied (koha-testing-docker): 19.71 s After: 1.81 s -- You are receiving this mail because: 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/
