php程序内存优化之数组操作优化

create table optimization(
    id INT NOT NULL AUTO_INCREMENT,
    value VARCHAR(10) NOT NULL,
    PRIMARY KEY(id)
);

<?php
    $dsn = 'mysql:dbname=test;host=127.0.0.1';
    $user = 'root';
    $password = 'root';

    try {
        $dbh = new PDO($dsn, $user, $password);
    } catch(PDOException $e) {
        echo 'Connection failed: ' , $e->getMessage();
    }
    $begin = microtime(true) * 1000;

    $count = 100;
    $stmt = $dbh->prepare('INSERT INTO `optimization` (id, value) VALUES(:id, :value)');
    $stmt->bindParam(':id', $id);
    $stmt->bindParam(':value', $value);
    for ($i = 0; $i < $count; $i++)
    {
        $id = '';
        $value = $i;
        $stmt->execute();
    }

    $end = microtime(true) * 1000;
    echo 'excuted : ' , ($end - $begin) , ' ms';

<?php
    $dsn = 'mysql:dbname=test;host=127.0.0.1';
    $user = 'root';
    $password = 'root';

    try {
        $dbh = new PDO($dsn, $user, $password);
    } catch(PDOException $e) {
        echo 'Connection failed: ' , $e->getMessage();
    }

    $begin = microtime(true) * 1000;
    $dbh->beginTransaction();
    try {
        $count = 100;
        $sql = 'INSERT INTO `optimization` (id, value) VALUES ';
        $sql_arr = array();
        $sql_str = '';
        for ($i = 0; $i < $count; $i++)
        {
            $sql_arr[] = ("('', $i)");
        }
        $sql_str = implode(',', $sql_arr);
        $sql .= $sql_str;
        $stmt = $dbh->prepare($sql);
        $stmt->execute();
        $dbh->commit();
    } catch(Exception $e) {
        $dbh->rollBack();
        echo $e->getMessage() . '<br>';
    }

    $end = microtime(true) * 1000;
    echo 'excuted : ' , ($end - $begin) , ' ms';