If you run a query and the results don't fit in memory  you can use dbSendQuery()  dbFetch() and dbClearResults() to retrieve the results in batches By default dbFetch() will retrieve all available rows: use n to set the maximum number of rows to return