title: Is there a Alternative to optimistic locking
body: <p>I'm working on a project where we collect (last_x, counters ) information about a account.
  User actions could result in multiple business events being generated. When a single user action on the web, results in more than one event, it will trigger an update to USER HISTORY table. </p>
  
  <p>We do optimistic locking to make sure the all the events result in a update to USER HISTORY table.</p>
  
  <p><strong>Problem:</strong></p>
  
  <p>Optimistic locking results in extra reads ( when conflicts are detected, read again and update ) and extra writes ( after resolving the conflict). </p>
  
  <p><strong>Solutions Tried:</strong></p>
  
  <ul>
  <li>Every event results in insert to USER HISTORY Table
      - More history information, results in poor read performance.</li>
  </ul>
  
  <p>Is there any other alternative?</p>