We have a soft-delete functionality for donations and memberships, but the deleted donations are not used for anything. The deleted donations have a performance impact, because they need to be included in every query and index that returns "all donations" (e.g. analytics and reports). To improve performance, we could regularly delete soft-deleted entries.
Description
Description
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Open | None | T203654 Improve Code and Architecture of Fundraising Frontend | |||
| Open | None | T203684 Improve code and architecture of Fundraising Operation Center | |||
| Open | None | T203679 Refactor fundraising database schema | |||
| Open | None | T271731 Permanently delete soft-deleted donations and memberships |