On 25 May 2015, at 2:09pm, ShadowMarta at yahoo.de wrote: > What am I missing here ?
My guess is that you are expecting FTS tables to act the same as normal tables. They don't. They're specially created and don't have the same indexing and other behaviour. The questions you're asking make sense if you're just talking about normal SQLite tables. It may be that you should split your data up. For most of your relations you should be declaring normal tables. Only the content you need to search quickly needs to be in an FTS table. Simon.