Dear all, a few weeks ago, I asked the question below but did not get any response on it. A few minutes ago, I found a remark (cf. http://osdir.com/ml/freedesktop.tracker/2008-07/msg00085.html) that it might be possible to avoid the "redundant" storage of document information in the fts *_content tables. Has anyone an implementation available for fts3 which does not store data in the fts3 *_content tables but only uses the *_segdir and *_segments tables Best Martin
Dear all, we plan to use FTS in embedded devices for address search. One requirement is to save storage. Assume I create a table FTS_addresses (Field1,Field,2,..Fieldn), where Field1 is an identifier for my addresses. If now field1 would be used as document id, and if every fts query returns only the field1 value, we would not need to store the contenttable at all, which would save space. Can we get such a functionality from fts3, or do we have to implement this on our own. Best Martin _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users