Hey!
After I loaded all the items in the database for my app, the performance has decreased tremendously. Before loading everything in the database, it was all fine and I could easily test my app with 10 things in the list it is showing on the homepage.
I’ve opened my app so you can view. Who would be so kind to help me understand what operations are causing the app to totally freeze?
Thanks a lot!
Yannick
Hey @yannickdoteu
I’ve just had a really quick look at your app and I think you need to look at the way you’re doing your search for data in the repeating group.
The table that is driving that repeating group has about 8.5k records
A couple of tips…
The first part ‘Search for Onderwerps’ has a couple of constraints which is good. But then you’re adding a filter over the top of that to filter down back on another dropdown list. What’s happening here is that you’re pulling down however many records is returned from the first part and then using the users browser to filter the list down some more from that dropdown list. It’s super inefficient to do this as you’re pulling down way more data then you need. The resulting list of items in the repeating group was like 30 at most, but I feel like you must have been pulling thousands down given the speed.
Then by using the sort function here vs in the initial search you’re also sorting using the users browser vs. on the server side, which will also slow things down.
Josh @ Support Dept
Helping no-code founders get unstuck fast 
save hours, & ship faster with an expert 
on-demand
I post daily about no-code and Bubble on Twitter 
Just taken a look at this and yep it’s unacceptably slow. Another thought in addition to @josh24, is why don’t you paginate that RG on the homepage to show only say 10 per ‘page’. That would make it appear a lot quicker as it would render X items whilst loading the rest in the background.
