On 04/04/2016 05:43 AM, Domingo Alvarez Duarte wrote:
> Hello !
>
> I'm testing fts5 on a database with data from hacker news (around 13M
> records) and it took more than 2 hours to index, I have this application to
> log all queries executed for debugging and although the search isn't slow
> it's
And the indexes are not supposed to be used ?
Shouldn't a index cover the ranking too ?
It seems a mistake for me.
Cheers !
> Mon Apr 04 2016 11:07:51 AM CEST from "Dan Kennedy"
> Subject: Re: [sqlite] FTS5 problem ? more than
>3,000
>queries !
>
>
Hello !
I'm testing fts5 on a database with data from hacker news (around 13M
records) and it took more than 2 hours to index, I have this application to
log all queries executed for debugging and although the search isn't slow
it's making a lot of queries.
Is this normal ? More than 3,000 qu
On 3 Apr 2016, at 11:43pm, Domingo Alvarez Duarte wrote:
>
> Is this normal ? More than 3,000 queries ?
It looks to me as if your SELECT is returning 3000 results. If you do a search
for a rarer term does it execute fewer queries ? For instance you might search
for '' instead of ''.
Simo
4 matches
Mail list logo
