yii批量更新

为什么80%的码农都做不了架构师？>>>   

public function actionTestDbCommit1()
	{
		$start = time();
		$count = intval($_GET['count']);
		$data = $_GET['data'];
		$connection = Yii::app()->db;
		for($i = 1; $i <= $count; $i++)
		{
			$sql = "insert into test_table(name, seq) values('$data', '$data')";
			$command = $connection->createCommand($sql);
			$command->execute();
		}
		$end = time();
		echo "单条更新<br/>count=$count <br/>data=$data <br/> time=" . ($end - $start) . "秒";
	}
	public function actionTestDbCommit2()
	{
		$start = time();
		$count = intval($_GET['count']);
		$data = $_GET['data'];
		$connection = Yii::app()->db;
		$transaction = $connection->beginTransaction();
		try
		{
			for($i = 1; $i <= $count; $i++)
			{
				$sql = "insert into test_table(name, seq) values('$data', '$data')";
				$connection->createCommand($sql)->execute();
				if ($i != 0 && $i % 10000 == 0)
				{
					$transaction->commit();
					$transaction = $connection->beginTransaction();
				}
			}
			if ($i % 10000 > 0)
			{
				$transaction->commit();
			}
			else
			{
				echo "$i no exec <br/>";
			}
		}
		catch (Exception $e)
		{
			echo "error $e->getMessage() <br/>";
			$transaction->rollback();
		}
		$end = time();
		echo "使用事务批量更新<br/>count=$count <br/>data=$data <br/> time=" . ($end - $start) . "秒";
	}
	public function actionTestDbCommit3()
	{
		$start = time();
		$count = intval($_GET['count']);
		$data = $_GET['data'];
		$connection = Yii::app()->db;
		$connection->setAutoCommit(false);
		try
		{
			for($i = 1; $i <= $count; $i++)
			{
				$sql = "insert into test_table(name, seq) values('$data', '$data')";
				$connection->createCommand($sql)->execute();
				if ($i != 0 && $i % 10000 == 0)
				{
					$connection->setAutoCommit(true);
					$connection->setAutoCommit(false);
				}
			}
			if ($i % 10000 > 0)
			{
				$connection->setAutoCommit(true);
			}
		}
		catch (Exception $e)
		{
			echo $e->getMessage();
		}
		$end = time();
		echo "非事务批量更新<br/>count=$count <br/>data=$data <br/> time=" . ($end - $start) . "秒";
	}
	public function actionTestDbCommit4()
	{
		$start = time();
		$count = intval($_GET['count']);
		$data = $_GET['data'];
		$connection = Yii::app()->db;
		try
		{
			$sql = "";
			for($i = 1; $i <= $count; $i++)
			{
				$sql .= "insert into test_table(name, seq) values('$data', '$data');";
				if ($i != 0 && $i % 10000 == 0)
				{
					$connection->createCommand($sql)->execute();
					$sql = "";
				}
			}
			if ($i % 10000 > 0 && empty($sql) == false)
			{
				$connection->createCommand($sql)->execute();
			}
		}
		catch (Exception $e)
		{
			echo $e->getMessage();
		}
		$end = time();
		echo "拼接sql方式批量更新<br/>count=$count <br/>data=$data <br/> time=" . ($end - $start) . "秒";
	}

转载于:https://my.oschina.net/penngo/blog/119362