Actually, as you suggest this is a critical performance topic. Complementing @mikeloc great suggestions, please review an insightful discussion in this forum with awesome contributions by many folks including frequent contributors @lottemint.md and @nocodeventure
In short, strong arguments made for building light objects indirectly related as much as possible. Here, another great resource (paid) by @petter. One of the best resources on building for performance in Bubble that I have come across: