[sqlite] How is this query so fast?

Hello, I have a table which contains a set of words. These are stored in a table called 'patterns_content' with pattern as unique key. There is a FTS4 table named 'patterns' which has 'content=patterns_content' set. It will have only ASCII characters. Something like, ab abd abcd . .

Re: [sqlite] How is this query so fast?

Forgot to add. I got idea for last method from this[1] post. [1] http://sqlite.1065341.n5.nabble.com/fast-string-prefix-matching-td10777.html On Thu, Aug 2, 2012 at 11:36 PM, Navaneeth.K.N navaneet...@gmail.comwrote: Hello, I have a table which contains a set of words. These are stored in a