4 ms·
Thanks for all your effort! I haven't tinkered with mealmaster files in ages but you've given me a reason to dig through my old CDs to find my archives. Unlike
by bshipp 6y ago
Thanks for all your effort! I haven't tinkered with mealmaster files in ages but you've given me a reason to dig through my old CDs to find my archives. Unlike zip files of old code or software, recipes are likely just as useful today as they were 10 or 20 years ago.
One thing I noticed when working with Sqlite3 recently is that they've implemented full text searching.
https://www.sqlite.org/fts3.html https://www.sqlite.org/fts3.html
I found the implementation simple to employ and incredibly fast and powerful. Perhaps it could be a helpful tool in a generic search? Just an idea!
- wedesoft 6y agoThanks 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!
- bshipp 6y agoI 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!