Hello! This query produce full-scan of the FTS3 virtual table 'data': sqlite> select count(*) from data where rowid in (1); ^CError: interrupted After 30 minuts I cancel the query.
sqlite> explain query plan select count(*) from data where rowid=1; 0|0|TABLE data VIRTUAL TABLE INDEX 1: sqlite> explain query plan select count(*) from data where rowid in (1); 0|0|TABLE data VIRTUAL TABLE INDEX 0: 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