title: speedup my search query in android sqlite?
body: <p>I create a program that search between 20000 record.
  I implement this search in</p>
  
  <pre><code>edit.addTextChangedListener(new TextWatcher() {...}
  </code></pre>
  
  <p>When user enter a character search query execute.but very slow return answer.</p>
  
  <p>this is my record table :</p>
  
  <pre><code>id, prodname, proddet, prodid, refid
  </code></pre>
  
  <p>and this is my search query:</p>
  
  <pre><code>SELECT DISTINCT prodname , prodid FROM tblProd where ((prodname like '%"+name+"%') or (proddet like '%"+name+"%') and (prodname IS NOT NULL))  LIMIT 20;
  </code></pre>
  
  <p>Also my table is fts3 and use this query for search :</p>
  
  <pre><code>SELECT DISTINCT prodname  , prodid  FROM  tblProd where (tblProd MATCH  '"+name+"*')  LIMIT 20
  </code></pre>
  
  <p>but speed is slow like other table.</p>
  
  <p>any one can help me how to speed up this search without delay.
  and sorry for my bad english.</p>