Reduce Aggravating Aggregation: Improve the Performance of History or Status Tables

(Merrill Aldrich) A third-party system that I manage has “history” or “status” tables following a common pattern: in the database, there is some entity (in my case, apartment units) that is labeled with a value indicating the entity’s status, and the value changes over time. Each of these entities h

Read More - Register for Free Membership