Re: [sqlite] FTS substring behavior

2012-11-08 Thread Yongil Jang
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 >

Re: [sqlite] FTS substring behavior

2012-11-08 Thread Paul Vercellotti
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

Re: [sqlite] FTS substring behavior

2012-11-08 Thread Yongil Jang
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

Re: [sqlite] FTS substring behavior

2012-11-08 Thread 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.

[sqlite] FTS substring behavior

2012-11-08 Thread Paul Vercellotti
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?