I have a FTS5 virtual external content table, defined following way: CREATE VIRTUAL TABLE PostFTS using fts5( ThreadID, Content, content=Posts, content_rowid=id, tokenize='porter unicode61 remove_diacritics 1');
The following query executes for 4..5ms: select count() from PostFTS where PostFTS match 'innermost'; But if I include in the WHERE clause any other condition, the execution time increases by a factor of 100 - up to 500..700ms: select count() from PostFTS where PostFTS match 'innermost' and ThreadID = 6; Both queries returns a value around 15000. What I am missing? Or such behavior is normal and expected. -- http://fresh.flatassembler.net http://asm32.info John Found <johnfo...@asm32.info> _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
