DMZ 1.7.1 (DataMapper OverZealous Edition)

[eluser]Mareshal[/eluser]

Code:

function test(){
        
        //DMZ Test
        $this->benchmark->mark('start');
        
        for($i=1; $i<=1000; $i++){
            $u = new User();
                $u->username = "test";
                $u->password = "test";
                $u->first_name = "test";
                $u->last_name = "test";
            $u->save();
        }
        
        $this->benchmark->mark('end');
        
        echo "<Br>DMZ: ".$this->benchmark->elapsed_time('start', 'end');
        
        
        //Active Record Test
        $this->benchmark->mark('start');
        
        for($i=1; $i<=1000; $i++){
                $insert['username'] = "test";
                $insert['password'] = "test";
                $insert['first_name'] = "test";
                $insert['last_name'] = "test";        
        
            $this->db->insert('user', $insert);
        }
        
        $this->benchmark->mark('end');
        
        echo "<Br>Active Record: ".$this->benchmark->elapsed_time('start', 'end');

    
    //Pure SQL Test
    $this->benchmark->mark('start');
        
    for($i=1; $i<=1000; $i++){
        mysql_query("INSERT INTO `user` (`username`, `password`, `first_name`, `last_name`) VALUES ('foo', 'bar', 'chh','asdasdasd')");
    }
    $this->benchmark->mark('end');
        
    echo "<Br>Pure SQL: ".$this->benchmark->elapsed_time('start', 'end');
    
    }

DMZ: 1.9113 , 2.0543 , 2.2763 s
Active Record: 1.7360 , 1.5230 , 1.6436 s
Pure SQL: 1.2210 , 1.1639 , 1.2076 s

How did I run them?
On DMZ run, AR and SQL were commented
On AR run, DMZ and SQL were commented
On SQL run, AR and DMZ were commented