[Koha-devel] Conventions for CLI scripts

[Robin Sheat]

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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 473 bytes
Desc: This is a digitally signed message part
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20141023/3d20be1e/attachment.pgp>