title: Optimal and efficient way to store 200 fields inside a table in mysql
body: <p>I am working on a new project in which requirement is to store around 200 fields in a table, what could be the most efficient and best possible way to do the same. The table would contain around 1,000,000 rows and the same would keep on increasing.</p>
  
  <p>I have created two tables and divided the fields based on their frequency of update and select.</p>