SQLite Forum

JOINs with FTS5 virtual tables are very slow
Thanks Simon, good to know this. My db is primarily read only. Once I fill it with data, it is used to power an API. So I can fill the db, create the indexes, run `ANALYZE` on all the tables, and be ready.