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
> ..."
>
>
>
> 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
>>
>>
>>
>>
--