SQLite Forum

JOINs with FTS5 virtual tables are very slow
Yes, My experience was similar. Running analyze on the two culprit tables in a 5 GB database took a couple of seconds, maybe less. That said, I will follow Simon’s advice and run analyze consciously, not automatically via a program. Should do the trick for me. Thanks all, especially to Dan Kennedy, for helping solve this.