Hello! I did rewrite the subj and now my test database is 4.6x smaller. It's fine, of cource. But there is the problem with speed of count(*) query:
sqlite> select count(*) from file_text; 8430 CPU Time: user 0.508032 sys 0.012000 sqlite> select count(*) from file_text_content; 8430 CPU Time: user 0.004000 sys 0.000000 Really, unpacking full database content is slow operation. Is it possible to fix this on virtual-table level? Best regards, Alexey Pechnikov. http://pechnikov.tel/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
