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

2012-08-17 Thread Mike Girard
Wow. You guys are so fast. After posting, I found out about the Toolbar and looked at the SQL myself. I feel stupid for asking. What threw me off was some code I saw of Massimo's where he used raw SQL to get a record count. I found myself wondering why. On Friday, August 17, 2012 6:00:20 PM

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

2012-08-17 Thread Cliff Kachinske
I'm not really a DAL guru, but I can't imagine DAL doing that. Every dbms I know about has something like "SELECT COUNT(id) WHERE ..." On Friday, August 17, 2012 5:54:32 PM UTC-4, Mike Girard wrote: > > Does this load the rows into memory? > > db(db.person.id > 0).count() > > > If so, is ther