On Fri, Dec 4, 2009 at 6:44 PM, Pavel Ivanov <paiva...@gmail.com> wrote: >> (2) Is there a way to create FTS virtual table that only holds the >> fulltext index and not the data itself? (This way I'd able to solve >> the problem by creating a separate FTS3 table and hooking triggers on >> r/w queries). > > Can you exclude text fields from your table, put it into separate FTS > table and put rowid from FTS table to the main table? This way you > exclude double storage of text information, your data will be linked > with text as it is now and you will be able to create indexes on main > table as well as perform full-text search in FTS table. The only thing > you will miss is indexes on text fields but probably you don't need > them when you have FTS... > > (snip)
I guess I could do that. Of course I'll need to change all the queries accessing the text fields in the table. Thanks, Vladimir. > Pavel _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users