Loading...

gambas-user@lists.sourceforge.net

[Prev] Thread [Next]  |  [Prev] Date [Next]

Re: [Gambas-user] Result object, again Ian Haywood Wed Nov 24 21:00:18 2010

2010/11/25 Benoît Minisini <[EMAIL PROTECTED]>:
>> good evening all,
>> i have another question about my eternal punishment: the result object :-)
>>
>> caveat answered to a former question about results in general:
>>  >If you got into the habit of reading all the
>>  >records you've selected into memory (or even if the Result object
>>  >worked
>>  >that way behind the scenes...), you'd soon find everything breaking >with
>>  >Out Of Memory errors as soon as you start doing anything serious.
>>
>> my question now is, how the result works behind the scenes, is there a
>> counter (result.index?) that tells a layer (the driver?) which record is
>> to be given back?
>>
>> regards,
>> tobi
>>
>
> A result object stores the entire query of the result in memory, because of
> the stupidity of most SQL backends.
Postgresql definately supports cursors (being able to retrieve rows in groups
and not hold them all in memory)

Ian

------------------------------------------------------------------------------
Increase Visibility of Your 3D Game App & Earn a Chance To Win $500!
Tap into the largest installed PC base & get more eyes on your game by
optimizing for Intel(R) Graphics Technology. Get started today with the
Intel(R) Software Partner Program. Five $500 cash prizes are up for grabs.
http://p.sf.net/sfu/intelisp-dev2dev
_______________________________________________
Gambas-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/gambas-user