title: MySQL fulltext performance solution
body: <p>How to deal with queries like :</p>
  
  <pre><code>select ... from ... where match(field1) against('someA') and match(field2) against('someB') limit 50
  </code></pre>
  
  <p>If results returned by condition match(field1) against('someA') &amp; match(field2) against('someB') are both huge,the entire query will be very,very slow.</p>
  
  <p>A solution for this?</p>