My table is taking a long time to load

bubble-dev3 · 2024-09-23T14:51:15.730Z

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.

Captura de tela 2024-09-23 1146561533×495 33.8 KB

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.

tunacardak · 2024-09-23T14:57:22.312Z

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

bubble-dev3 · 2024-09-23T15:01:05.435Z

Bubble

Bubble Editor - Mutua Systems

Build stuff without code and launch a startup without a tech-cofounder! Bubble is a visual programing language. Instead of typing code, use a visual editor to build applications.

tunacardak · 2024-09-23T15:09:38.827Z

You should change the app view setting as everyone can view. It’s under settings → General

bubble-dev3 · 2024-09-23T15:19:00.935Z

Done!!

tunacardak · 2024-09-23T15:42:26.611Z

can you check your link in incognito mode because still it doesn’t work

bubble-dev3 · 2024-09-23T15:56:53.321Z

Try it now! Please

tunacardak · 2024-09-23T16:19:44.408Z

In every page load do you need to write all the api results to the database?

bubble-dev3 · 2024-09-23T16:25:36.552Z

No, each time the page loads, I perform a search for this data in the database and update it in a custom state.

image1557×545 47.4 KB

tunacardak · 2024-09-23T16:31:36.081Z

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

georgecollier · 2024-09-23T16:45:06.472Z

Tunahan Cardak:

You should change the app view setting as everyone can view. It’s under settings → General

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!

bubble-dev3 · 2024-09-23T16:48:28.800Z

It worked to apply the API call directly in the repeating group; I will analyze the implications of not saving the data, thank you!

tunacardak · 2024-09-23T16:50:05.304Z

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