title: how much extra Space/RAM/CPU is used by apache solr?
body: <p>I am using MySQL database for my webapp.
  I need to search over multiple tables &amp; multiple columns, it very similar like full text searching inside those columns.</p>
  
  <p>I need know your experience of using any Full Text Search API (eg. solr/lucene/mapReduce/hadoop etc..) over using simple SQL in terms of :</p>
  
  <ol>
  <li>Speed performance</li>
  <li><strong>Extra space usage</strong></li>
  <li><strong>Extra CPU usage</strong> (is it continuously building index? )</li>
  <li>How long it takes to build index or it get ready for use?</li>
  <li>Please let me know your experience of using these frameworks.</li>
  </ol>
  
  <p>Thanks a lot!</p>