Re: [web2py] Get row count for query without loading data into memory

2012-08-17 Thread Bruno Rocha
It returns no Row. It return an "int" object db(db.person.id > 0).count() *Translates to "SELECT count(*) FROM PERSON WHERE ID > )"* *So the result is an integer object.* *Bruno Cezar Rocha** - @rochacbruno* rochacbr...@gmail.com | Mobile: +55 (11) 99210-8821 www.CursoDePython.com.br | www.ro

[web2py] Get row count for query without loading data into memory

2012-08-17 Thread Mike Girard
Does this load the rows into memory? db(db.person.id > 0).count() If so, is there a DAL way to get a row count for a query without loading the rows? Thanks. Mike --