On 3/10/11 5:11 AM, Ed Leafe wrote: > The two work on different things. 'Limit' limits the amount of data > returned by the database; 'fetchmany' is used by the local dbapi > cursor*after* the data is returned from the database to iterate through the > returned records a few at a time. The fetch* methods don't affect the amount > of data returned from the database; they are completely local.
Actually, I think this is database independent. I think you are correct for MySQL, but for others fetchmany() will just get that many rows from the backend. Paul _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev Searchable Archives: http://leafe.com/archives/search/dabo-dev This message: http://leafe.com/archives/byMID/[email protected]
