[web2py] Re: Simple SQL perfoemance issues

2016-06-22 Thread Grzegorz DzieƄ
Thanks a lot! That solved my issue. On Wednesday, June 22, 2016 at 7:48:18 PM UTC+2, Anthony wrote: > > First, note that without specifying an orderby, the order of the records > is not guaranteed to follow any particular rule, so you can't be sure which > record .last() will return. > > Second,

[web2py] Re: Simple SQL perfoemance issues

2016-06-22 Thread Anthony
First, note that without specifying an orderby, the order of the records is not guaranteed to follow any particular rule, so you can't be sure which record .last() will return. Second, your current query is returning *all *records from the database, which involves parsing each record into a Row