Re: [sqlite] fts virtual table questions

2011-05-12 Thread Richard Hipp
On Thu, May 12, 2011 at 4:07 PM, Paul Shaffer wrote: > I didn't get an answer to my earlier question on fts. I guess it's > difficult area. > > Should an fts virtual table always be re-created from scratch when the > database is opened by the application before you start using fts commands? > No.

[sqlite] fts virtual table questions

2011-05-12 Thread Paul Shaffer
I didn't get an answer to my earlier question on fts. I guess it's difficult area. Should an fts virtual table always be re-created from scratch when the database is opened by the application before you start using fts commands? I see that the fts tables are not deleted when the database is closed

[sqlite] fts virtual table questions

2011-02-28 Thread Paul Shaffer
I am still testing my results and am new to fts. To use fts, is "create virtual table" required every time my program runs and opens the sqlite database? I see that the table (plus a few other related fts tables) is physically present in the database after my program closes. I would prefer to not