Re: Correct behavior of ItemQuery?

Yasushi Iwata <[email protected]> Mon, 9 Feb 2009 11:52:30 +0900

Newsgroups	gmane.comp.python.quotient.dev
Message-ID	<[email protected]>

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.

Regards.