title: Database design: Where to store account balance?
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/4373968/database-design-calculating-the-account-balance">Database design: Calculating the Account Balance</a><br>
    <a href="https://stackoverflow.com/questions/6341883/should-the-users-account-balance-be-stored-in-the-database-or-calculated-dynami">should the user&#39;s Account balance be stored in the database or calculated dynamically?</a>  </p>
  </blockquote>
  
  
  
  <p>Where is the best place to store the user's account balance and why?</p>
  
  <p>1) "Transaction" table, as calculated at the time when the transaction occurred or </p>
  
  <p>2) "Account" Table, updated every time the user login or at the time the transaction occurred.</p>