TalkPHP - View Single Post - mysql -- most efficient way to batch process UPDATES

SOCK · 05-05-2008, 06:20 PM

Can you give us the specifics of the query itself? In other words, is it something like your example where you're setting the same value for every record that match on a set of record ID values?

If that's the case, then use a single query referencing a list of ID values using the IN operator, e.g.

Code:

UPDATE yourTable
SET column1 = 'new value'
WHERE id IN (3,5,7,9,11,13);

A transaction is an interesting idea; what engine type are you working with? MyISAM or InnoDB?

05-05-2008, 06:20 PM	#2 (permalink)
SOCK The Acquainted Join Date: Nov 2007 Posts: 154 Thanks: 31	Can you give us the specifics of the query itself? In other words, is it something like your example where you're setting the same value for every record that match on a set of record ID values? If that's the case, then use a single query referencing a list of ID values using the IN operator, e.g. Code: UPDATE yourTable SET column1 = 'new value' WHERE id IN (3,5,7,9,11,13); A transaction is an interesting idea; what engine type are you working with? MyISAM or InnoDB? __________________ I reject your reality, and substitute my own.