title: What is the best approach to calculate a formula which changes value each day?
body: <p>I use the following columns stored in a SQL table called tb_player:</p>
  
  <p><code>Date of Birth (Date)</code>, <code>Times Played (Integer)</code>, <code>Versions (Integer)</code></p>
  
  <p>to calculate a "playvalue" (integer) in the following formula:</p>
  
  <pre><code>playvalue = (Today - Date of Birth) * Times Played * Versions
  </code></pre>
  
  <p>I display upto 100 of these records with the associataed playvalue on a webpage at any time.</p>
  
  <p>My question is, what is the most efficient way of calculating this playvalue given it will change only once a day, due to the (today-date of birth) changing? The other values (times played &amp; versions) remain the same.</p>
  
  <p>Is there a better way than calculating this on the fly each time for the 100 records? If so, is it more efficient to do the calculation in a stored proc or in VB.NET/C#?</p>