il Jang <yongilj...@gmail.com>
> To: General Discussion of SQLite Database <sqlite-users@sqlite.org>
> Sent: Thursday, November 8, 2012 2:26 PM
> Subject: Re: [sqlite] FTS substring behavior
>
> How about look at following URL?
>
> https://github.com/jonasfj/trilite
>
anks,
Paul
From: Yongil Jang <yongilj...@gmail.com>
To: General Discussion of SQLite Database <sqlite-users@sqlite.org>
Sent: Thursday, November 8, 2012 2:26 PM
Subject: Re: [sqlite] FTS substring behavior
How about look at following URL?
https://github.com/jonasfj/trili
How about look at following URL?
https://github.com/jonasfj/trilite
AFAIK, FTS doesn't support substring search.
I also tried to edit FTS to find substring by changing simple tokenizer.
It was worked partially, but not a good solution to use generally.
2012/11/9 Dan Kennedy
On 11/09/2012 01:49 AM, Paul Vercellotti wrote:
Hi there,
I wanted to clarify if FTS could provide any optimization for substring matches
like '*ion*' or similar?
No. I think it will actually search for tokens that start with the 4
ASCII characters "*ion" if you try that.
Dan.
Hi there,
I wanted to clarify if FTS could provide any optimization for substring matches
like '*ion*' or similar?
That is, does it only scan the token index for matching tokens to locate the
main table records that contain those tokens, or does it do a full table scan
of the main table?
5 matches
Mail list logo