Hi! I started receiving emails about workload spikes on my app yesterday evening. I am on the Starter Plan and it quickly used up all WUs. I allowed overages for a time, but quickly saw the charges accumulating. I disabled overages overnight and still was faced with more charges in the morning. I am not sure how that is possible. I’ve looked at the metrics and server logs, and am still stumped on the issues. I’ve emailed support and my email was transferred to a workload spike team and it could be awhile for a response. I was wondering if anyone here could help me identify the issues happening.
The issue seems to be with Fetching Data and Displaying a list in a Repeating Group. I’m not sure where to go from here and how to fix.
Thank you all in advance for any help or insight!!
Are you having nested Repeating Groups ? Also what is the size of the data being displayed in your Repeating Group ? sounds like it’s something like “inventory” or something, What list were you trying to display in your Repeating Group ?
As far as I know, the list size will be multiplied by the number of rows to be displayed in your Repeating Group hence the WU spike.
No I don’t believe so. The page that workflow is on is just a list of items filtered by user.
Can you please show a print screen of this Repeating Group ? Also how many items are being displayed .?
Here is what the repeating group looks like in the editor. There was one user who was very active around the time of these spikes. This user has 480 items in her list. (It is an inventory/sales app). From the server logs it appears she was making updates to individual items. The list repopulates after every update so I can see how having it reload a lot could use up some WUs. I’m not seeing any actions in the server log that are more than 10 WUs. Most are 0.6 WUs. I’m not understanding where almost 800,000 WUs were used.
can you post a screenshot of the workflow when a user edits something? Maybe there’s a recursive workflow or DB trigger running?
Sure! Here is the workflow when a user edits/updates an item’s info. There are probably more efficient ways of doing some of the things I have, but here is what I have currently. I appreciate the help!
that’s a fair few steps - you might be best to break that out into custom events
the wu report says it’s been used to display data on the page so it’ll most likely be within the repeating group itself not the front end workflows
check if you have any of the following:
- search within a search within a search ie search for contacts where this contacts email is in search of emails etc
- advanced filters on the search
- load all items immediately (and you have a very long list) - consider paging it
- searches for show/hide conditions within the repeating group that use search within search/adv filters
- repeating groups within repeating groups
2 Likes
I wonder if those ‘make changes total’ could be one step instead of running them after each ‘thing’ update.
I would like to test this because I’m not sure, but maybe DB Triggers would be an option for something that complex? Example: update other/blank only when “other/blank SKU.name-before change IS NOT other/blankSKU.name” or something.
Basically it’s checking to see if the value was actually changed before doing that workflow. If there are a bunch of ‘do searches’ in those ‘make change’ steps, that’s probably the reason.
Although, to spike to almost 800K runs, something seems off.
That is a good idea I’ll have to look into. Something definitely seems off however. This is my normal monthly workload usage and I’ve never been close to using all my Starter Plan’s WUs. And now January is right where I’d expect it to be with workflows, but suddenly ten times as many WUs being consumed. I hope I hear back from Bubble support soon.
Thanks for all the tips! I’m sure my app could be more efficient. I do have pages on that repeating group but I will look into some of the other ideas you mentioned! Thanks again
