title: how to do full text search in elasticsearch
body: <p>I have very big data in on table (more then 4lc rows). Right now i am using mysql full text search but its very slow.</p>
  
  <p>I google and found many blog which suggest to use elastic search for searching.
  We are testing if elastic search will help in fast search.</p>
  
  <p>but we are getting opposite result(mysql better search), but i doubt if i have used elastic search in correct way. Elastic search query i used is:-</p>
  
  <pre><code>{
   "query" : {
       "bool" : {
          "must" : {
             "query_string" : {
                 "query" : "goog*",
                 "default_field" : "search"
             }
          }
       }
   },
   "size" : 1000
  }
  </code></pre>
  
  <p>For same search in mysql we used </p>
  
  <pre><code>SELECT SQL_NO_CACHE * FROM table1 WHERE (MATCH (search) AGAINST (' +goog*' IN BOOLEAN MODE))
  </code></pre>
  
  <p>I get time diff:-
  elastic time = <code>0.34929585456848</code></p>
  
  <p>mysql time = <code>0.02162504196167</code></p>
  
  <p>Any suggestion where i am wrong I will very much appreciate </p>