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]>