For Full Text Search, FTS3/4 are from hundreds to thousands of times faster than plain vanilla SQLite using "LIKE". According to
http://cvs.hwaci.com/fts3.html#section_2 , although FTS3/4 are included with the SQLite core source code, they are not enabled by default.
Question: by any chance will the SQLite in Calibre 2.0 or later ever have FTS3/4 enabled?
A new plugin I am working on scans all of the text fields (author, title, series, comments, sorts, publisher) across all of the books in a library looking for particular substrings to relate the books to each other. I am using LIKE and other approaches, but couldn't help but dream about FTS3/4......