title: How to improve sqlite like statement performance
body: <p>I create a table use such schema:</p>
  
  <pre><code>CREATE TABLE wordIndex(id integer primary key, word varchar(128), offset integer, length integer);
  CREATE INDEX word_idx on wordIndex(word);
  </code></pre>
  
  <p>Now the table have about 450,000 row records.When I use Like statement Below on ipod4, the performance is not good:
      select * from wordIndex where word like 'test acces%';
  Use explain output:</p>
  
  <pre><code>explain select * from wordIndex where word like 'test acces%';
  0|Trace|0|0|0||00|
  1|Goto|0|16|0||00|
  2|OpenRead|0|2|0|4|00|
  3|Rewind|0|14|0||00|
  4|String8|0|2|0|test acces%|00|
  5|Column|0|1|3||00|
  6|Function|1|2|1|like(2)|02|
  7|IfNot|1|13|1||00|
  8|Rowid|0|4|0||00|
  9|Column|0|1|5||00|
  10|Column|0|2|6||00|
  11|Column|0|3|7||00|
  12|ResultRow|4|4|0||00|
  13|Next|0|4|0||01|
  14|Close|0|0|0||00|
  15|Halt|0|0|0||00|
  16|Transaction|0|0|0||00|
  17|VerifyCookie|0|2|0||00|
  18|TableLock|0|2|0|wordIndex|00|
  19|Goto|0|2|0||00|
  </code></pre>
  
  <p>May be I need build an additional inverted index  to improve the performance or ...?
  Thanks advance!</p>