Check out this documentation from Bubble that may help you better understand this stuff.

https://manual.bubble.io/architecture-optimization-and-limits-of-the-bubble-engine/performance-and-scaling