Speed and performance

[simonperks81]

Hi All

After some help on the performance and speed of my app. I am on the paid plan at the moment and the app is really struggling with both the web view and when i view data in the editor.

The app is based for store audits, as such the store is required to fill out various fields and take pictures. In total there is 90 questions for a store with say 20 of them been images.

My database structure is simply a table that stores the question, store, answer and image (if it has one). So far we have carried out 4 stores - so around 400 lines maximum in the table.

The app though is grinding to a halt, i am trying to retrieve data in the editor and it is taking around 40 seconds to load 50 records and often bombs out.

Is there any suggestions on how to handle this? Should i save my images in a different location and have a link or something to pull them through?

Any help would really be apptreciated

Thanks

[cmarchan]

Hello @simonperks81

Performance Q&A guide

So some overall guidelines. Note that these kinds of guidelines definitely have a sell-by date, since we’re always trying to optimize slow stuff, but here are some of the big performance levers: The more data a search fetches, the longer it takes. That probably sounds pretty basic, but we routinely see pages that fetch thousands of data items on page load. Or, we sometimes see searches that only fetch a few things – but each thing has KBs or MBs of text data stored in its field. Bubble …

RG vs "Search for" (performance questions)

@rpetribu The conventional wisdom after much time learning from knowledgeable folks in this forum (my understanding of it). And through my own experience building apps is to: build light objects minimize list fields (only when less than 100 entries), only use them purposefully relate objects indirectly but both ways when necessary preload searches feed from preloaded searches avoid inflow searches (… hence preloading them) mnimize back and forths between client and server use custom events ex…

The Ultimate Guide to Bubble Performance - 156 pages of optimizing tips

Hey everyone, I’m very happy to announce that I’m releasing my book The Ultimate Guide to Bubble Performance today. [image] It’s a 156 page PDF available on Gumroad that dives deeply into the hard-earned lessons I’ve learned over five years of full-time Bubbling, focusing on: how to determine whether Bubble is the right tool for your project: the pros, cons and limitations from a performance perspective how to set up your app to load pages, process workflows and edit database records at ma…

[simonperks81]

Thanks for these, read through a lot of them previously.

It id the editor database that i am finding frustrating, this is grinding to a halt - i now have a message saying “some items in your database exceed 10mb” - how is this calculated? is it per item or for instance i have a list of images and it is the multiple of that?

[cmarchan]

I see.

Split sections into reusables. This will take the load off the editor.

[simonperks81]

Sorry, not explained this well.

It is the data itself inside the editor - Data > App Data > Table

I have even created a view to just bring back 2 columns and it still takes too long

[cmarchan]

You are using the backend to manage your data?

… the backend is not built for that

[simonperks81]

Hi, again sorry for the confusion - screenshot attached.

I am trying to simply review the data that has been entered, when clicking it takes forever - hence there must be a problem.

[cmarchan]

No problem. That is how the dB view works in the backend…. Slow

Consider adding views with a few fields (columns) to speed things up.

[simonperks81]

Hi, already done that and added a view with 2 columns and it is still not working correctly.

has to be that table though as others loading fine. Assuming it is the images and Bubble is somehow slowed down by these even though they are not part of the query/view.

[cmarchan]

Create a satellite data type that is super light along with each new audit. Include the audit score plus a few other info fields.

When you want to see the full audit details show them in another page or in a popup. Just make sure to load the rg with the satellite data type.

In the backend data they will load at regular speed.