I have created a website which accepts donations for projects through Cart Throb. It will display the total amount of donations made by querying the Purchased Donations channel and summing these values for a specific project.
My concern is as this table gets larger I don’t know what the indexes are so the query is going to take longer and longer to return…
I had another approach where I update a total field associated with the project if the transaction is successful.
What would be the best approach to this issue?
Thanks!