Understanding FTS3/FTS4: What are virtual tables and to search from it having a searchable non-virtual table? Understanding FTS3/FTS4: What are virtual tables and to search from it having a searchable non-virtual table? sqlite sqlite

Understanding FTS3/FTS4: What are virtual tables and to search from it having a searchable non-virtual table?


Copying all text to a (temporary) FTS table would be rather slow.

To avoid the overhead of storing duplicates of the text in the two tables, you can use an external content table.

To keep the data in the two table synchronized, you can use triggers; see the link above for an example.