# C# - Calculate A Formula Which Changes Value Each Day?

Feb 25, 2009I use the following columns stored in a SQL table called tb_player:

Date of Birth (Date), Times Played (Integer), Versions (Integer)

to calculate a "playvalue" (integer) in the following formula:

playvalue = (Today - Date of Birth) * Times Played * Versions

I display upto 100 of these records with the associataed playvalue on a webpage at any time.

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 & versions) remain the same.

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#?