On Sun, 28 May 2017 14:23:47 +0200 Clemens Ladisch <[email protected]> wrote:
> It might be better to use a single FTS lookup for both words: > > select count() from PostFTS where PostFTS match 'innermost ThreadID:6'; > Thanks! This is indeed much faster. But I am passing the search query as a parameters. How to proceed then? Should I build one composite string query, like this: Pseudocode: ?1 = keyword + ' ThreadID:' + num2str(threadID); select count() from PostFTS where PostFTS match ?1; Or I can make it another way: ?1 = keyword ?2 = threadID select count() from PostFTS where PostFTS match ?1 ThreadID:?2; -- http://fresh.flatassembler.net http://asm32.info John Found <[email protected]> _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
