[Newbies] PostgresV2 and bulk resultsets
Yanni Chiu
yanni at rogers.com
Wed Nov 28 07:04:04 UTC 2007
Thanks for the enhancement. It seems to me that the implementation is
case-specific and could be implemented using the equivalent SQL calls
without changing the PostgresV2 code. In any case, the squeaksource
project is world writable, so you can add an enhanced version yourself.
What I would like to do at some point is to support V3 protocol, and at
the same time, introduce a streaming protocol where the rows would be
read using a #next method (so the result rows would stay on the server
until they're requested). Also, #cancel would stop reading any further
rows from the server.
--
Yanni
Petr Fischer wrote:
> 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 at lists.squeakfoundation.org
>>> http://lists.squeakfoundation.org/mailman/listinfo/beginners
>>>
>>
>> _______________________________________________
>> Beginners mailing list
>> Beginners at lists.squeakfoundation.org
>> http://lists.squeakfoundation.org/mailman/listinfo/beginners
>>
>
More information about the Beginners
mailing list