After thinking about this a little more, I'm even more convinced that storing patron reading history in a separate table / materialized view is the right way to go.
I agree the table should track everything the patron might need to see as it existed at the time of circulation to avoid problems with bibs, etc. being deleted or modified after the fact.
Jason, can you clarify "and not even bother to keep the expired circs around"?
After thinking about this a little more, I'm even more convinced that storing patron reading history in a separate table / materialized view is the right way to go.
I agree the table should track everything the patron might need to see as it existed at the time of circulation to avoid problems with bibs, etc. being deleted or modified after the fact.
Jason, can you clarify "and not even bother to keep the expired circs around"?