SQLite Forum

SQLite FTS Module Creation

SQLite FTS Module Creation

(1) By anonymous on 2021-05-25 12:16:30 [source]

Hi all,

following question. In my project we previously used the FTS module for a full text search in the database in a column with big XML content. The FTS module was enabled in an additional virtual table which took the content from another table. The process of creating this table caused long installation times and also the database to be twice as big.

We changed the approach: the FTS module is enabled directly on the original table when it is empty and then the table is filled afterwards. Does this work from a conceptional point of view? From our tests the full text search still worked, but we cannot do an extensive search test, as the database is very big (20GB+).