John Found wrote:
> the execution time increases by a factor of 100
>
> select count() from PostFTS where PostFTS match 'innermost' and ThreadID = 6;

This is the same as:

  select count() from PostFTS where PostFTS match 'innermost' and PostFTS match 
'ThreadID:6';

It might be better to use a single FTS lookup for both words:

  select count() from PostFTS where PostFTS match 'innermost ThreadID:6';


Regards,
Clemens
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to