Main page
Contents:

Recently visited pages:

Model Donors2

This model keeps track of all the donation ids each donor has made.

Donor data is partitioned by donor id. Each partition contains the list of donation ids for a specific donor. This enables efficient queries and updates for individual donors, and supports scalable storage as the number of donors grows.

{DonorId}     {DonationId} {DonationId}

Partitioning on donor id allows for:

  • Fast lookup of a donor’s donations
  • Simplified scaling as donor count increases

This partitioned information is used to calculate statistics for the DonorDashboardStats model and the donor dashboard.


By J.W. Morsink