logo       

Re: PostgresV2 and bulk resultsets: msg#00101

lang.smalltalk.squeak.beginners

Subject: Re: PostgresV2 and bulk resultsets

OK. I implemented this functionality. Look at comment in method:
PGConnection>>execute: sqlString withRowBlock: aRowBlock

Is possible to add attached changesets to PostgresV2 package? (by Yanni Chiu)

Thanks, pf

On 27.11.2007, at 17:01, Franz Josef Konrad wrote:

This should help you...
<http://article.gmane.org/gmane.comp.lang.smalltalk.squeak.general/109157 >
I don't know if there is an API in newer versions from Postgresql where you can query the number in the result set.

Regards,
Franz Josef

Petr Fischer schrieb:
Hi,

if I call:
conn execute: 'select * from one_milion_table'
it seems that all table rows are loaded into memory - right?

Is there an easy way to only iterate (do:) result set records without internal loading bulky resultset into some sort of internal arrays?

Thanks, pf
------------------------------------------------------------------------

_______________________________________________
Beginners mailing list
Beginners@xxxxxxxxxxxxxxxxxxxxxxxxxx
http://lists.squeakfoundation.org/mailman/listinfo/beginners


_______________________________________________
Beginners mailing list
Beginners@xxxxxxxxxxxxxxxxxxxxxxxxxx
http://lists.squeakfoundation.org/mailman/listinfo/beginners


Attachment: PGConnection-executeAndCheckResult.st
Description: Binary data

Attachment: PGConnection-executewithRowBlock.st
Description: Binary data

Attachment: smime.p7s
Description: S/MIME cryptographic signature

_______________________________________________
Beginners mailing list
Beginners@xxxxxxxxxxxxxxxxxxxxxxxxxx
http://lists.squeakfoundation.org/mailman/listinfo/beginners
<Prev in Thread] Current Thread [Next in Thread>
Google Custom Search

News | FAQ | advertise