On 10 Feb 2011, at 4:00pm, Yuzem wrote: > Thanks you but what I want to do is to count without using count(distinct > col) because it is much slower than count(*).
How much slower. Did you make an index SQLite could use for that query ? A good index for that might be People_ID,Capacity_ID but it might be faster with those two the other way around. Try them both out and see which gives you faster results. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users