title: MySQL Full Text Search way too slow
body: <p>I am doing a search on a table which has around 2M entries. When I'm doing the basic search, the request time is below 0.1 sec:</p>
  
  <pre><code>SELECT * FROM entreprises WHERE MATCH (L1, LIBVOIE, LIBCOM) 
                                  AGAINST(:term2 IN BOOLEAN MODE) LIMIT 0,10
  </code></pre>
  
  <p>Which is correct, but when I put the relevance part of the query:</p>
  
  <pre><code>SELECT *, MATCH(L1,LIBVOIE, LIBCOM) AGAINST(:term) as score 
  FROM entreprises 
  WHERE MATCH (L1, LIBVOIE, LIBCOM) AGAINST(:term2 IN BOOLEAN MODE) 
  ORDER BY score DESC LIMIT 0,10
  </code></pre>
  
  <p>query time jumps to tens of seconds.</p>
  
  <p>Can someone explain why is that happening?</p>