while loop slows performance down - online

[eluser]Lone[/eluser]
In my opinion there would be no performance benefits and if there was they would be minimal. If there was anything I think it would increase memory usuage as the whole $query variable is moved from the model, to the controller to the view.

Heres a quick sample to head you in the right direction:

Model

Code:

function get_studies() {
  // DB stuff here
  $result = $query->result();
  return $result;
}

Controller

Code:

function casestudies() {
  $data['casestudies'] = $this->Model_name->get_studies();
  $this->load->view('casestudies',$data);
}

View

Code:

<?php foreach($casestudies as $casestudy): ?>
        <div class="casesummary-home">
<a href="casestudies"><img src="images/&lt;?php echo mt_rand(1,6) ?&gt;/thumbs/image1.jpg">title ?&gt;" />  </a>
</div>
&lt;?php endforeach; ?&gt;