Re: [sqlite] Does a search on an external content FTS table use the index of the underlying content?

2012-09-19 Thread E. Timothy Uy
Thanks Richard. In the case of using a index modifying tokenizer like Porter, is there a way to know which of the MATCH terms it actually matched on or is that lost information? On Wed, Sep 19, 2012 at 3:44 AM, Richard Hipp wrote: > On Wed, Sep 19, 2012 at 2:42 AM, E. Timothy Uy wrote: > > > Le

Re: [sqlite] Does a search on an external content FTS table use the index of the underlying content?

2012-09-19 Thread Richard Hipp
On Wed, Sep 19, 2012 at 2:42 AM, E. Timothy Uy wrote: > Let's say I have a table Data_content(term TEXT UNIQUE) which has an > indexed column 'term'. I then create an FTS4 table using > > CREATE VIRTUAL TABLE Data USING fts4 (content="Data_content", term); > > If I later search using SELECT * FRO

[sqlite] Does a search on an external content FTS table use the index of the underlying content?

2012-09-18 Thread E. Timothy Uy
Let's say I have a table Data_content(term TEXT UNIQUE) which has an indexed column 'term'. I then create an FTS4 table using CREATE VIRTUAL TABLE Data USING fts4 (content="Data_content", term); If I later search using SELECT * FROM Data WHERE term IN (...), does it use the indexes generated in D