How to send email for more than 1000 user............

[eluser]imzyos[/eluser]
just and idea ok...

THIS SUCKS

Code:

class foo extends Controller {

  function send()
  {
    $query = $this->db->getwhere('addresses', array('mailsent'=>'N'), 50, 0);
    
    if ($query->numrows() != 0) {
    foreach ($query->result() as $address) {
      $this->email->to($address->email);
      $this->email->send();
      $this->db->update('addresses', array('mailsent'=>'Y'), array('email'=>$email));
      redirect('foo/send');
    }
  }
}

a lot of httprequest =S