doctrine/tests/Doctrine/Tests/ORM/Performance/InsertPerformanceTest.php

<?php

namespace Doctrine\Tests\ORM\Performance;

require_once __DIR__ . '/../../TestInit.php';

use Doctrine\Tests\Models\CMS\CmsUser;

/**
 * Description of InsertPerformanceTest
 *
 * @author robo
 * @group performance
 */
class InsertPerformanceTest extends \Doctrine\Tests\OrmPerformanceTestCase
{
    protected function setUp() {
        $this->useModelSet('cms');
        parent::setUp();
    }

    /**
     * [romanb: 10000 objects in ~8 seconds]
     */
    public function testInsertPerformance()
    {
        $s = microtime(true);

        $conn = $this->_em->getConnection();

        $this->setMaxRunningTime(10);

        //echo "Memory usage before: " . (memory_get_usage() / 1024) . " KB" . PHP_EOL;

        $batchSize = 20;
        for ($i=1; $i<=10000; ++$i) {
            $user = new CmsUser;
            $user->status = 'user';
            $user->username = 'user' . $i;
            $user->name = 'Mr.Smith-' . $i;
            $this->_em->persist($user);
            if (($i % $batchSize) == 0) {
                $this->_em->flush();
                $this->_em->clear();
            }
        }

        //gc_collect_cycles();
        //echo "Memory usage after: " . (memory_get_usage() / 1024) . " KB" . PHP_EOL;

        $e = microtime(true);

        echo ' Inserted 10000 objects in ' . ($e - $s) . ' seconds' . PHP_EOL;
    }
}