For those who don’t know, SQLite has a full text search module in the full distribution – but on the iPhone, it isn’t there. This means that you have to resort back to good old fashioned LIKE %word% in your SELECT statements. Because LIKE doesn’t speed up when using indexes (it is a full text compare) – it is fairly slow compared to a direct =

When planning your SQLite implementations on the iPhone, make sure you have your data structured in the best possible way for LIKE to fly over it!