Split huge array of rows to smaller chuncks

gistfile1.php

/*
 * The idea is to test against the value $max_allowed_packet (in bytes)
 * and make sure our sql don't get bigger than that.
 * Before executing our query (the bigger INSERT the less overhead.
 */

// $rows is an array containing the rows to insert
while(count($rows)) {                                                                                                                                                                                 
  $sql = "INSERT IGNORE INTO `table` VALUES ".
    implode(',',array_splice($rows,0,25000)).
    ";".PHP_EOL;
  if(!$db->query($sql))
    die($db->error);
}

Perhaps something like this: http://stackoverflow.com/a/7942680/803002