0

What are external content tables and how can they be used instead of fts3 virtual tables for Full Text Search? Is it worth to use fts4 instead of fts3?

Bhushan
  • 205
  • 2
  • 14
  • What specific part of [the documentation](http://www.sqlite.org/fts3.html#*fts4content) do you not understand? – CL. Jul 20 '16 at 17:59
  • I am not understanding how external content table avoid duplicate copies of data – Bhushan Jul 21 '16 at 12:20
  • See [shadow tables](http://www.sqlite.org/fts3.html#*shadowtab). – CL. Jul 21 '16 at 12:25
  • So it does copy the data for specified columns? But the documentation says that external content table can access the columns that it does not have. but I cannot figure out how to use it? – Bhushan Jul 21 '16 at 12:38
  • There are examples. – CL. Jul 21 '16 at 12:42
  • Wait just read the example. it says that it takes data from the content table when requested. So it does not copy the data. Am I correct? – Bhushan Jul 21 '16 at 12:45

0 Answers0