Re: [sqlite] Need some tips on using FTS5 with SQLite

On Wed, 14 Feb 2018 14:26:21 + Wout Mertens wrote: > I too am interested in this answer, I still have to start using fts5. > > What would be interesting is to see the `EXPLAIN QUERY PLAN [query]` for > each of your queries, so as to see what causes the slowness. > It is clear what causes t

Re: [sqlite] Need some tips on using FTS5 with SQLite

I too am interested in this answer, I still have to start using fts5. What would be interesting is to see the `EXPLAIN QUERY PLAN [query]` for each of your queries, so as to see what causes the slowness. On Thu, Feb 8, 2018, 7:14 PM John Found, wrote: > > I am using FTS5 for pretty complex sear

[sqlite] Need some tips on using FTS5 with SQLite

I am using FTS5 for pretty complex search in my application, but recently, trying to make it even more complex I faced some problems that are more general than only FTS5. I have a forum engine where are several tables for the threads, for the posts, for the users etc. At first I want to be abl