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 UTC-4, Cliff Kachinske wrote: > > 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 > ...<query>" > > > > 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 there a DAL way to get a row count for a query without loading >> the rows? >> >> Thanks. >> >> Mike >> >> >> >> --