John Found wrote:
> Pseudocode: ?1 = keyword + ' ThreadID:' + num2str(threadID);
>
> select count() from PostFTS where PostFTS match ?1;
That works.
> ?1 = keyword
> ?2 = threadID
> select count() from PostFTS where PostFTS match ?1 ThreadID:?2;
That is not valid SQL. You have to create a singl
On Sun, 28 May 2017 14:23:47 +0200
Clemens Ladisch 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
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 si
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
4 matches
Mail list logo