Open JustZack opened 6 months ago
A place to record values about something in the cache table. these tables could dynamically update instead of all at once.
E.G. The table `MembersMeta" records metadata about members, like:
BillCosponsors
Bills
MemberTerms
MemberVotes
Would ensure DB resources aren't tied up by something that never changes.
Using Views for this is probably best. Definitely implement into the Schema enforcer.
A place to record values about something in the cache table. these tables could dynamically update instead of all at once.
E.G. The table `MembersMeta" records metadata about members, like:
BillCosponsors)Bills)MemberTerms)MemberVotes< table does not exist yet)MemberTerms(current/last term))MemberTerms(current/last term))Would ensure DB resources aren't tied up by something that never changes.
Using Views for this is probably best. Definitely implement into the Schema enforcer.