Hacker News Reader

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 would need to run on 400 MByte of text!

View on HN

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!

Reply on news.ycombinator.com