On Apr 19, 2011, at 8:31 AM, Olaf van der Spek wrote: > On Wed, Apr 6, 2011 at 2:24 PM, Olaf van der Spek <[email protected]> > wrote: >> Hi Drizzlers, >> >> How does one do bulk updates in Drizzle? One can easily do bulk >> inserts via multi-row insert. One can do a single update to a lot of >> rows. But one can't do a lot of updates (in a single statement). >> Suppose I've got 10000 key value (int) pairs that need to be updated. >> How would you do it? >> In MySQL I've (ab)used insert ... on duplicate update, but that >> doesn't work anymore due to a safer SQL mode. >> I'd like to avoid using temporary tables. >> >> See also https://bugs.launchpad.net/drizzle/+bug/691974 > > Somebody? > Perhaps I am misunderstanding you, but would a transaction not be what you're asking for?
BEGIN; UPDATE ... ; UPDATE ... ; ... COMMIT; That is, if you wanted to have all those statements go through at the same time. I think if you wanted to improve speeds of updates, you may want to look at PBMS, the BLOB streaming stuff, which functions similar to HandlerSocket. I'm not sure if HandlerSocket can be built into Drizzle but, last I remember, PBMS is already there ready to go as a plugin. Tim _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
