I’m having issues when running a query on one of my tables. This table receives a list of objects from Algolia, and currently, it handles up to about 1,700 Algolia objects, as shown in the print below.
The column relevant_org_list receives the list of objects.
When I query the strategy_orgs table, it always takes a long time to load. Displaying the Algolia objects in a repeater group also takes a lot of time, but as the number of elements decreases with the searches, the loading time decreases as well.
I started having this issue recently; before, I could load the complete list without any problems, and now even checking the table in the database is taking longer.
Hey, welcome to the forum. I think you make lots of request while loading the page. I can check for you if you share the app here
You should change the app view setting as everyone can view. It’s under settings → General
can you check your link in incognito mode because still it doesn’t work
In every page load do you need to write all the api results to the database?
No, each time the page loads, I perform a search for this data in the database and update it in a custom state.
Can you check the strategy orgs table? Even opening in bubble data panel, it takes too long. If you don’t need to store the data I highly recommend you to make the api call on the repeating group
1 Like
Please remember to make this private again, and also remember that making this ‘Everyone can view’ gives anyone access to any data in your app and allows them to login as any user!
1 Like
It worked to apply the API call directly in the repeating group; I will analyze the implications of not saving the data, thank you!
I’m glad it worked. I recommend you to do the saving with the backend workflow when you need it. This way, no matter how long the process takes, the user will not be affected by it
Forum
Academy
Marketplace
Showcase
Pricing
Features
