1) Is concatenation on UPDATE performed in-place?
For example, with the following:
CREATE TABLE example (content TEXT);
INSERT INTO example(content) VALUES ('Hello, world!');
UPDATE example SET content = content || ' How are you?' WHERE rowid = 1;
Is the old value copied out to memory before being concatenated with
the new value and re-inserted, or is SQLite able to avoid that step?
(This is for an incremental index of documents on a low-memory
device.)
2) For the same operation an FTS4 table:
CREATE VIRTUAL TABLE example USING fts4(content TEXT);
Is FTS4 smart enough to know not to remove and re-add the 'hello' and
'world' from its shadow tables before adding the 'how', 'are' and
'you'?
Thanks,
Hamish
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
