sers@sqlite.org
|
| cc:
|
| Subject: Re: [sqlite
At 8:56 AM -0500 9/15/05, Puneet Kishor wrote:
Hence, it might be worthwhile maintaining the meta information no
matter what... most of the folks won't ever notice it, and everyone
would marvel at how quickly COUNT(*) was returning the results.
You are assuming that everyone wants to do a
> Interesting. But, with the above suggestion, every INSERT or DELETE
> would slow down anyway as much as it would have were SQLite to maintain
> meta information itself, no?
>
> .
>
> Hence, it might be worthwhile maintaining the meta information no
> matter what... most of the folks
On Sep 15, 2005, at 8:43 AM, D. Richard Hipp wrote:
On Thu, 2005-09-15 at 13:59 +0100, Da Martian wrote:
Hi
I have 3 million rows in a table which takes up about 3.1GB on disk.
The
count(*) is slow.
I have run the analyze, but apart from creating the stats table it
does
nothing.
Any
On Thu, 2005-09-15 at 13:59 +0100, Da Martian wrote:
> Hi
>
> I have 3 million rows in a table which takes up about 3.1GB on disk. The
> count(*) is slow.
>
> I have run the analyze, but apart from creating the stats table it does
> nothing.
>
> Any reason why this is? Can it be improved ?
You'll need to provide more information to get a helpful answer.
What version are you using? What indexes are present on the table? How
was the table defined?
-Tom
> -Original Message-
> From: Da Martian [mailto:[EMAIL PROTECTED]
> Sent: Thursday, September 15, 2005 8:59 AM
>
6 matches
Mail list logo