[Deprecated] DMZ 1.5.3 (DataMapper OverZealous Edition)

[eluser]OverZealous[/eluser]
Those queries you reference are actually caused by CI's get_fields() method. It is used to determine the names of the fields available on the table. You can reduce them, through the production cache (I can't link to it at this moment, but it's in DMZ's docs).

However, be careful. Turning on the cache while in development will cause errors and possibly data corruption. You should only enable it on production servers that have no active development, and clear the cache whenever any changes are made.

Also, I would bet that the fields query is insignificant in terms of resource cost.

Overall, DMZ has an extremely low query overhead for an ORM.

Finally, you should still be doing all validation in your controller, even with DMZ. I recommend using a structure like this:

Code:

function edit($id) {
    $u = new User();
    $u->get_by_id($id);
    if($this->input->post('submit')) {
        $u->name = $this->input->post('name');
        if($u->save()) {
            redirect('users/view/' . $u->id);
        }
    }
    $this->load->view('user_edit', array('user' => $u));
}

Then in your view, you can check to see if $user->error->all is empty to decide if an error occurred, as well as get your form input re-filled out for free.

(Sorry if there are errors, I'm typing this on a netbook. Tiny keyboards suck!)