Dear All,

After some searching I still could not find the answers to the following
questions. Any answers or pointers would be greatly appreciated.

(1) In my FTS-enabled database, I want to clone some document, stored in a
binary format. (Which means copying the same contents to a new row with a
different ID). I do not have immediate access to the original fulltext of
the document, but I have it's FTS3 index in the database. Can I somehow
clone the FTS3 virtual row, like I can clone the document row, without
retrieving and re-indexing the fulltext? 

(2) Is it possible to optimize the size of the database by eliminating the
storage of the original text in FTS3 virtual table? I found this possible
for FTS2 ("FTS: Custom Tokenizer / Stop Words" thread), but is there a
similar reliable method for FTS3?

Thanks in advance,
Yaroslav.
-- 
View this message in context: 
http://www.nabble.com/FTS3%3A-%281%29-cloning-index-rows--%282%29-not-storing-original-text--tp18821175p18821175.html
Sent from the SQLite mailing list archive at Nabble.com.

_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to