[Deprecated] DMZ 1.6.2 (DataMapper OverZealous Edition)

[eluser]Mirage[/eluser]
Something wrong with how DMZ (or CI???) opens database connections - I'm running out of connections when saving objects in a loop:

Code:

public function shuffle_questions($exam_id)
    {
        // Load the questions in entered order
        $question = new Sae_Question();
        $question->where('exam_id' , $exam_id)
                 ->order_by('id')
                 ->get();

        $questions = $question->all;
        shuffle($questions);
        
        foreach ($questions as $i => $q)
        {
            $q->seq = ($i+1);
            $q->save();
        }

        redirect('/admin/sae/questions');
        
    }

Apparently a new db connection is established on every save() call for some reason. That doesn't seem right. A quick look at the log shows this:

Code:

DEBUG - 2010-02-03 11:44:45 --> Database Driver Class Initialized
DEBUG - 2010-02-03 11:44:45 --> Database Driver Class Initialized
DEBUG - 2010-02-03 11:44:45 --> Database Driver Class Initialized
DEBUG - 2010-02-03 11:44:45 --> Database Driver Class Initialized
DEBUG - 2010-02-03 11:44:45 --> Database Driver Class Initialized
DEBUG - 2010-02-03 11:44:45 --> Database Driver Class Initialized
DEBUG - 2010-02-03 11:44:45 --> Database Driver Class Initialized
DEBUG - 2010-02-03 11:44:45 --> Database Driver Class Initialized
DEBUG - 2010-02-03 11:44:45 --> Database Driver Class Initialized
DEBUG - 2010-02-03 11:44:45 --> Database Driver Class Initialized
DEBUG - 2010-02-03 11:44:45 --> Database Driver Class Initialized
DEBUG - 2010-02-03 11:44:45 --> Database Driver Class Initialized
DEBUG - 2010-02-03 11:44:45 --> Database Driver Class Initialized
DEBUG - 2010-02-03 11:44:45 --> Database Driver Class Initialized
DEBUG - 2010-02-03 11:44:45 --> Database Driver Class Initialized
ERROR - 2010-02-03 11:44:45 --&gt; Severity: Warning  --&gt; mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Too many connections /Users/juesch/Sites/childneurologysociety.org/www/system_172/database/drivers/mysql/mysql_driver.php 70
ERROR - 2010-02-03 11:44:45 --&gt; Unable to connect to the database

Help?