title: More resource usage friendly search than fulltext search?
body: <p>I just use following code right now.</p>
  
  <pre><code>SELECT terms FROM searches WHERE MATCH(q) AGAINST('search term') LIMIT 20;
  </code></pre>
  
  <p>The table is MyISAM 90MB. terms has FULLTEXT INDEX and it is varchar(255). There are 1,000,000 rows on the table.</p>
  
  <p>I wonder if there is any solution which is more resource usage friendly than fulltext search on MySQL? Especially in terms of memory.</p>
  
  <p>By saying solution, I refer to any solution such as other types of databases, table structures etc. </p>
  
  <p>and if the solution would be adaptable to a standart VPS or hosting in general, it would be extremely super duper perfect!</p>
  
  <p>Thanks for your time!</p>