title: CodeIgniter Active Record: Load One Row at a Time
body: <p>The normal <code>result()</code> method described in the documentation appears to load all records immediately.  My application needs to load about 30,000 rows, and one at a time, submit them to a third-party search index API.  Obviously loading everything into memory at once doesn't work well (errors out because of too much memory).</p>
  
  <p>So my question is, how can I achieve the effect of the conventional MySQLi API method, in which you load one row at a time in a loop?</p>