3 ms·

So if I am not mistaken this only works well when a query is well indexed?

• sktrdie 10y ago
  You mean when the database is well indexed? Yes. SQLite supports Full Text Search (https://sqlite.org/fts5.html https://sqlite.org/fts5.html) which builds all the indexes for you, allowing you to perform search-engine-like functionality. But you're right, it does require more attention towards index construction for site owners.