Paul Poulain schreef op di 21-10-2014 om 09:56 [+0200]: > mmm... I agree with this point, BUT, for large changes, MySQL really > does really not well with a huge single transactions. In this case, > the > only way is to do smaller transactions.
I've never noticed that, but perhaps the things I'm usually doing aren't quite big enough. However, it's not a big deal to batch up (say) 1,000 operations and then commit/not commit them if necessary. It does lose you some element of error recovery, but at least you can still do a real dry-run test and it'll fail safely if something is wrong. Or we could run postgres :) -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5FA7 4B49 1E4D CAA4 4C38 8505 77F5 B724 F871 3BDF
signature.asc
Description: This is a digitally signed message part
_______________________________________________ Koha-devel mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
