Re: [sqlite] sqlite performance problem

[D. Richard Hipp]

On Tue, 2005-04-12 at 16:17 -0700, Maksim Yevmenkin wrote:

> SELECT count(*) FROM (SELECT a,n1 FROM data WHERE a <= 18234721 GROUP BY a);
> 
> > time sqlite3 db < test.sql
> 300000
> 1024
> 1417
> 13.14u 1.06s 0:14.40 98.6%
> 

Have you tried doing the query like this:

  SELECT count(*) FROM (SELECT a,nl FROM data WHERE a-18234721<=0 GROUP
BY a);


-- 
D. Richard Hipp <[EMAIL PROTECTED]>