title: MySQL trigger vs application insert for history
body: <p>I have a main table in mysql and need a history table for tracking the changes in the table.</p>
  <p>I have 2 approaches.</p>
  <ol>
  <li><strong>trigger</strong> --&gt; create a trigger for the main table which inserts into history table for any change in the main table</li>
  <li>insert into the history table while inserting or updating in the main table from application</li>
  </ol>
  <p>I am checking which is the best approach with performance.</p>