3 ms·

Thanks for your suggestion. At the moment I am looking into bulk operations for categories. But I might give it a go later. Not sure how fast it will be. It wou

• bshipp 6y ago
  I ran it on a 67GB sqlite database with approximately 15 million rows in one table and 300 million in another and on an SSD it spit out a result in less than a second. On a mech drive its 5-10 seconds, but that's a factor of 10 faster than if I did a traditional WHERE clause with LIKE/GLOB. The drawback is that it increases the size of the database, almost exponentially depending on the number of columns you include in the FTS. But its fun to tinker with!