В сообщении от Thursday 19 June 2008 01:09:42 Teg написал(а): > I doubt the COUNT in Sqlite could be any faster. You really notice the > slowdown though, the first time you access the DB and nothing's in > cache.
I think, you can use index directly as create index id_idx on mytable(id); select count(id) from mytable where id>0; explain query plan select count(id) from mytable where id>0; 0|0|TABLE mytable WITH INDEX id_idx It's better than use count(*) with "where" condition. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
