Sorry for my dumbness but if something is wrong with my code please point
me the right line. I'm not so good in English if it comes to "object
instance count" and so. Yeah I know I should go and do some milkmaid job :)
but I'm curious.
I'm just define some variable:
lista = list()
last_row = None
next_page_number = 0
Go in a for loop that just assign the db query result one-by-one to row
variable.
After that I assign the TABLE() helper to a list variable. That is it.
2012. május 10., csütörtök 16:34:49 UTC+2 időpontban Bruce Wade a
következőt írta:
>
> Using direct sql query or DAL is going to cause the exact same problem in
> this situation.
>
> On Thu, May 10, 2012 at 7:28 AM, szimszon <szims...@gmail.com> wrote:
>
>> It's postgres:// in a
>> Version 1.99.7 (2012-04-23 11:26:23) dev of web2py, and
>>
>> Python 2.7.3 (default, Apr 20 2012, 22:44:07)
>> [GCC 4.6.3] on linux2
>>
>> python-psycopg2 2.4.5-1
>>
>>
>> 2012. május 10., csütörtök 15:40:36 UTC+2 időpontban rochacbruno a
>> következőt írta:
>>
>>> Just for curiosity, what happens if you do it in pure sql?
>>>
>>>
>>> for row in db.executesql("**select * from file_properties where id >
>>> 0"):
>>>
>>> # do something
>>>
>>>
>>> Does it have a lower memory usage?
>>>
>>>
>>> On Thu, May 10, 2012 at 4:14 AM, Bruce Wade < <bruce.w...@gmail.com>>wrote:
>>>
>>>> for row in db( db.file_**properties.id > 0 ).select(
>>>
>>>
>>>
>>>
>>> --
>>>
>>> Bruno Rocha
>>> [http://rochacbruno.com.br]
>>>
>>>
>
>
> --
> --
> Regards,
> Bruce Wade
> http://ca.linkedin.com/in/brucelwade
> http://www.wadecybertech.com
> http://www.fittraineronline.com - Fitness Personal Trainers Online
> http://www.warplydesigned.com
>
>
