On Thu, May 12, 2011 at 4:07 PM, Paul Shaffer <[email protected]>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. FTS tables persist just like any other table. > I see that the fts tables are not deleted when the database is closed. I > have not found enough info on sqlite virtual tables generally. > > Do you find it is possible to incrementally add and delete rows in the fts > virtual table (insert rows) as the application runs? Yes. That works fine for most users. > As new data is added I > would like to update the fts. > > If I delete rows in a table that was originally the source of data for fts > virtual table creation, the fts virtual table retains all the expired data. > In this case do you drop the fts table and recreate it, or try to delete > rows in the fts table? > Just delete the rows in the FTS table. > > I would gladly get all this info from docs and not bother you, but the docs > on sqlite fts don't have much practical everyday usage information. > > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
