Hi Marko,
It depends on a lot of factors like the size of your database, the size and content of the objects you’re loading, if you’re showing a list of items from a data object that’s already loaded to your page or using a “do search for”.
Here’s a response I got from Bubble’s support team with regards to lazy loading and efficiency:
"Jason here, from the Tier 2 App Design team, stepping in for Lucena.
If the repeating group does not have the “Show all items immediately” property checked, it will not load all results that match the search constraint in the client until it is required to be displayed. Bubble handles lazy loading by allowing users to create a vertical scrolling repeating group.
Here is a link to a video tutorial that shows how to create one: https://www.youtube.com/watch?v=vcWUgBEQPCk
If you have not already, I would also recommend reading these two sections of your manual for additional information about repeating groups:
Hope this information helps, let us know if you have any other questions."
“If a chat’s messages are stored in a field of the ‘Chat’ data type that is a list of things, then Bubble will load the entire list when that ‘Chat’ is loaded. Storing a list of database things on another thing has a hard limit of 10,000 records. Note that long lists can start to affect performance at a lower number, depending on how much data the records are holding and what kind of processing you apply. In many cases, using Do a search for instead of storing long lists will be more efficient.”
Hope this helps a little!