title: CSV to MySQL: Single table vs. multiple tables?
body: <p>I have a CSV file with 74 columns and about 60K rows. The contents of this CSV file have to be imported to a MySQL database, every month.</p>
  
  <p>After the data is inserted, the end-user can query the contents of the MySQL database with predefined filters.</p>
  
  <p>Putting everything in a single table would mean faster inserts, but slower reads. Splitting the content in multiple tables (with foreign keys) would mean slower inserts, faster reads and, I think, higher chance of failure.</p>
  
  <p>What do you think is the best option for me, or are there any other possibilities?</p>