On Friday, March 02, 2012 3:24:58 pm Paul McNett wrote:

> On 3/2/12 2:58 PM, Ricardo Araoz wrote:

> > Let's say your large SQL statement has millions of rows and you want to

> > group those rows in one data set and you want a subset of those rows in

> > another data set. I'd rather recieve two datasets with 100 rows each

> > (and processed in the dbms) than several million rows in one dataset and

> > having to process it locally to obtain both final data set results.

>

> Python's dbapi provides for this with cursor.fetchmany(num_rows). Dabo does

> not provide for this as it stands, because we always do cursor.fetchall().

In Dabo could you not use a tempCursor to get the same result?

http://paul.dabodev.com/doc/api/dabodoc/dabo.biz.dBizobj.dBizobj.html#Methods_getTempCursor

>

> Paul

>

Adrian Klaver

adrian.klaver@gmail.com

_______________________________________________

Post Messages to: Dabo-users@leafe.com

Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users

Searchable Archives: http://leafe.com/archives/search/dabo-users

This message: http://leafe.com/archives/byMID/201203021531.51831.adrian.klaver@gmail.com