Hi everyone,
I have a question regarding optimizing repeated database queries in Bubble. In my app, I need to check if a lesson has been watched by the current user. This information is used to change the color of a button and to update an image on the video page.
Currently, I am performing the same query in two different places: once in the button’s conditions and once in the image’s conditions. My concern is whether Bubble optimizes these identical queries to execute only once, or if it performs the query separately each time.
What would be the best practices for handling this scenario to ensure optimal performance?