On Mon, Apr 20, 2009 at 3:16 PM, Doug Williams <[email protected]> wrote:

3. For each status in the set, perform an SQL insert to save the status.


Or, I would hope, create an array of inserts and do a multi-insert, which
will be far faster than iterating through a list.

http://www.desilva.biz/mysql/insert.html

I'll bet you knew that, but I just had to note it because the performance
difference is enormous.

Nick
(not really a PHP guy, but years of (often painfully gained) MySQL
performance knowledge)

Reply via email to