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 > To: sqlite-users@sqlite.org > Subject: [sqlite] count(*) slow > > 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 ? >