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
