db->insert error

PHP Code:

        for($i = 0; $i < 1000000;$i++){
            $uid = uniqid('rsv', true);

            $this->db->set('uid',$uid);
            $this->db->set('data','toto' . $i);
            $this->db->reset_query();
            if ( $this->db->insert('ddr') == false ){

                break;
            }
            $this->db->reset_query();
        } 


Error message Fatal error: Allowed memory size of 134217728 bytes exhausted  in /system/database/DB_driver.php on line 703

PHP Code:

        for($i = 0; $i < 1000000;$i++){
            $uid = uniqid('rsv', true);

            $this->db->set('uid',$uid);
            $this->db->set('data','toto' . $i);
            $this->db->reset_query();
            if ( $this->db->insert('ddr') == false ){

                break;
            }
            $this->db->reset_query();
        } 


Error message Fatal error: Allowed memory size of 134217728 bytes exhausted  in /system/database/DB_driver.php on line 703

Um, 

well, first, you're resetting your query before you try to insert...

second... 1 million inserts is too much for your server's memory to handle at once with a for loop.

Did you have a question about it though?

PHP Code:

        for($i = 0; $i < 1000000;$i++){
            $uid = uniqid('rsv', true);

            $this->db->set('uid',$uid);
            $this->db->set('data','toto' . $i);
            $this->db->reset_query();
            if ( $this->db->insert('ddr') == false ){

                break;
            }
            $this->db->reset_query();
        } 


Error message Fatal error: Allowed memory size of 134217728 bytes exhausted  in /system/database/DB_driver.php on line 703

Um, 

well, first, you're resetting your query before you try to insert...

second... 1 million inserts is too much for your server's memory to handle at once with a for loop.

Did you have a question about it though?

 

The problem comes from the DB_Driver, to be precise the problem comes from a log array that is not reset. In the DB_Driver class the offending table is 'query_time' in the 'query' method.

Regards,