Hi everyone,
Is there any documentation/guidelines on database triggers for objects that gets under heavy load and what the impact of having database triggers is on performance?
Situation: I have an exam platform where a bunch of students perform an exam at the same time. This does result in a change in the object "StudentExam". As the performance of this is very important ( I don't want students to wait, i'm very careful with adding extra steps.)
Now I want to use a database trigger to send a realtime event to update the data on my Bubble app. And i'm wondering if it will have a big impact on my server usage as 100s of objects are gonna be changed at the same time.