On 03/10/2011 12:22 PM, Jacek Kałucki wrote: > Hi. > > Although Dabo cursor has support for limiting fetching result set > with the SQL limit clause, thing that is missing is fetching remaining > data from the set. > What do you think about using the fetchmany instead of limit? > It should be easier to retrieve batch results since this method is SQL > independent, > versus different limit/offset handling in by various backends. > We could also extend requery with the scope parameter like next/rest/all. >
I vote against using fetchmany instead of limit because they are doing quite different work. limit gets executed on the db server whereas fetchmany is a client method. I do not want the db server to do the work of processing millions of rows for every query. To be able to limit the workload of the server is a must for a sql db. Uwe _______________________________________________ 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]
