Re: Correct behavior of ItemQuery?

On 02:52 am, [email protected] wrote:
>2009/2/6  <[email protected]>:
>>
>>I seem to remember that I tried this and it definitely *didn't* work 
>>at
>>some point in the past, but it seems fine now.  Perhaps you could 
>>write
>>a patch which would fix the SQL generation for count() to do this
>>instead?  (Assuming it's reasonably efficient, I haven't yet checked
>>that it doesn't do anything too stupid like allocate and hold on to 
>>the
>>entire result set in memory.)
>
>I found a article of SQLite's COUNT by D. Richard Hipp.
>
>  http://osdir.com/ml/db.sqlite.general/2003-10/msg00326.html
>
>I filed a ticket #2834.

Thank you!  We'll address the patch as soon as we can.

Although, if you would like to speed up the process, writing a patch 
that includes unit tests would help.