>Is it possible to use FTS3 for search without storing the actual file >contents/search terms/keywords in a row. In other words, create a FTS3 >tables with rows that only contains an ID and populate the B-Tree with >keywords for search. >
Each FTS3 table t is stored internally within three regular tables : t_content, t_segments and t_segdir. The last two tables contain the fulltext index. The first table t_content stores the complete documents being indexed, and is only used when you call the offsets() or snippets() functions. So if you don't need those functions, you can cheat : a) call FTS3 to index your document as usual; b) do an update on the t_content table to remove the document text. I did play with that scenario, and gained quite a lot of disk space; however it's really a hack and maybe wouldn't work in future versions of SQLite. More on http://search.cpan.org/dist/DBD-SQLite/lib/DBD/SQLite/Cookbook.pod#Spari ng_database_disk_space _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
