title: groovy sql eachRow and rows method
body: <p>I am new to grails and groovy.
  Can anyone please explain to me the difference between these two groovy sql methods</p>
  
  <pre><code>sql.eachRow
  sql.rows
  </code></pre>
  
  <p>Also, which is more efficient?</p>
  
  <p>I am working on an application that retrieves data from the database(the resultset is very huge) and writes it to CSV file or returns a JSON format.</p>
  
  <p>I was wondering which of the two methods mentioned above to use to have the process done faster and efficient.</p>