Nick, Batch INSERTs are great for people looking to for performance tweaks. Serial INSERT statements within the iteration loop keeps things simple for those just starting out.
Doug Williams Twitter API Support http://twitter.com/dougw On Mon, Apr 20, 2009 at 4:14 PM, Nick Arnett <[email protected]> wrote: > > > 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) >
