title: Handle multiple tables of MySQL in with Solr 5.1.0?
body: <p>I have more than 30 tables in my MySQL database. Recently I have import data from my 1 table to Solr 5.1.0 using DataImporthandler and in my <strong>data-config.xml</strong> file, fire query of,</p>
  
  <pre><code>select * from table-name
  </code></pre>
  
  <p>But in my search I have to integrate more than 10 tables to give proper search result.</p>
  
  <p>The ways are to do this is</p>
  
  <p>1) To import data by using <strong>JOIN</strong> query in MySQL database and import it </p>
  
  <p><strong>OR</strong></p>
  
  <p>2) <strong>JOIN</strong> solr cores by importing full data separate tables.</p>
  
  <p>What shoud I do make it optimize?? and which is a good way? </p>