My app involves giving points for activities, for example points for attending an event. These points are later redeemable for products. Just like a loyalty programme. My question is on the impact of the loading speed of the app as the app gets bigger with more events and participations.
My setup is with two glide tables, one for the event and one for registration to the event.
Is it faster for the app, if for every reply to the event we
- increment a counter for the loyalty points or do a roll up from the replies
The roll-up is like you are calculating every time you load the app, so I thought this will make the app slower, especially as the events and participants increase. However, having roll-ups also have benefits such as ability to give different points for different events.