How to create a virtual table (when needed) and th...
# roomc
Clament John
11/09/2021, 9:10 AMHow to create a virtual table (when needed) and then drop it after the need?
I have to run full text search (fts4) on a set of Entities but this set is only decided after a certain user operation.
Example:
• Run Fts4 on a list of products (name and description).
• This list of products are only generated after a user action
• This list of products is generated after joining 3 tables.
Questions
1. Should I run a MATCH on a multi table JOIN? Or should I create a virtual table, then populate it with the results from the JOIN query and then run search on that?