0

I have a Note app which running for a while, now I am implementing full text search feature, I read a bout the sqlite fts3 & fts4 modules.

I want to know that after creating virtual table for full text search do I have to copy all data from my normal table to virtual table?

S.J
  • 3,063
  • 3
  • 33
  • 66

1 Answers1

0

The documentation says:

FTS tables are populated using INSERT, UPDATE and DELETE statements in the same way as ordinary SQLite tables are.

This is true even for external content tables.

CL.
  • 173,858
  • 17
  • 217
  • 259