On Mon, Aug 4, 2008 at 3:31 PM, yaroslavp <[EMAIL PROTECTED]> wrote:
> 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?
No. While I can't say for certain this will never happen, it's sort
of an esoteric thing to have. Do other database systems have this
kind of thing?
> (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?
I don't see why whatever you're doing for fts2 wouldn't work for fts3.
The code is very very very similar.
Long-term I think it would be useful to allow an index-only mode like
this, but to do it right would require fts to handle document
deletions in some different fashion. There are potentially other
reasons to make changes that would let this happen, but it's a pretty
big project so it probably won't happen anytime soon.
-scott
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
