On 18 Mar 2010, at 4:35pm, Alexey Pechnikov wrote: > sqlite> select count(*) from file_text; > 8430 > CPU Time: user 0.508032 sys 0.012000
Try counting just the primary key. Suppose your primary key is a column called 'id', try SELECT COUNT(id) FROM file_text Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users