Community Member Profile

Recent Blog Comments By Matthew Leventi

• Thoughts On Storing Duplicate / Calculated Data In The Database

  Posted on Apr 4, 2008 at 6:06 PM

  Hi, I see your point, which is essentially where/if aggregated data should be stored in the database. Caching information that is too expensive to runtime query for. My feelings are that this type of dare i see hack is fine, even though it denormalizes the database under the condition that... read more »

• Thoughts On Storing Duplicate / Calculated Data In The Database

  Posted on Apr 3, 2008 at 7:16 PM

  I don't know that much about Coldfusion but in RoR, something like this would be taken care of by the ORM. ActiveRecord auto maintains aggregated fields and I believe has different mechanisms for how they are updated.... read more »