title: Performance of truncate and insert vs update
body: <p>I have a table with more than 1 million records and table is growing everyday.I need to update two columns of that table everyday. What is the best way either to truncate the table and insert or update row wise?</p>
  
  <p>example :-</p>
  
  <p>today</p>
  
  <pre><code>userid activitycount 
  1         18    
  </code></pre>
  
  <p>tomorrow</p>
  
  <pre><code>userid  activitycount
  1        19   
  </code></pre>