[Feature Enhancement] Improved Performance for Popular Data Actions + Looking Ahead to Bulk Data in 2024

Announcements New features
1

Hi everyone,

We’re excited to share that popular ways of creating, deleting, and updating things in Bubble have gotten more performant:

  • The row limit for the workflow action Upload data as CSV is now 10x larger
  • The workflow action Make changes to a list of things is 3x faster
  • The workflow action Delete a list of things is 3x faster
  • The delete button in the app data tab is 3x faster

Increased Row Limits on CSV Upload in Run Mode

The fastest way to import large amounts of data into Bubble is by uploading a CSV file. Before, the workflow action that allows end-users to upload a CSV in run mode was restrictive because the number of rows that could be processed was very limited. The limits previously ranged from 100 rows on the Starter and legacy Personal plans, to 1,000 rows on the Team and legacy Production plans. As a result, many of you told us you’d resorted to hacky workarounds or simply lived with a tedious upload experience.

This update increases all previous row limits by 10x. The new limits are:

  • 1,000 rows on the Starter plan
  • 2,000 rows on the Growth plan
  • 10,000 rows on the Team plan
  • 30,000 rows on the Enterprise plan

If you are already on one of these plans, no action is needed — even if you’re already using the Upload data as CSV action in your workflows. If you are on a legacy pricing plan, you can switch to one of our new pricing plans to take advantage of these increased limits. For more details about our pricing plans, visit bubble.io/pricing.

Modifying and Deleting Things 3x Faster

Many of you have expressed how important it is for us to make it faster to update and delete data in Bubble. Over the past few months, we’ve streamlined aspects of our backend processing and made three common ways to update data ~3x faster:

  • Make changes to a list of things
  • Delete a list of things
  • The delete button in the app data tab.

Over the last three months, we’ve sped up these actions to complete in about one-third the time. All things equal, you can expect snappier a experience with no impact on WU consumption for both you (in the Bubble editor) and your users.

Looking Ahead

We recognize that these improvements are incremental. The work we’re doing now behind the scenes is helping us strengthen our technical foundation to set us up for bigger wins over the rest of this year and into 2024.

Our team is actively working to deliver on our product vision to support apps at any scale, with projects including:

  • Eliminating capacity timeouts that happen in the middle of workflows
  • Isolating backend and frontend capacity so that management tasks do not affect your app’s end-user experience
  • Providing native ways to reliably schedule and run backend workflows on the order of millions
  • Improving observability, management, and logs for long-running jobs
  • Redesigning the experience and enhancing performance for viewing and manipulating large datasets in the app data tab

These projects have been prioritized based on feedback from the Bubble community. We look forward to sharing more updates in the coming weeks and months!

45 Likes
2

@steven.harrington Is this faster than using the Data API Bulk Create endpoint? (assuming a limit of 1000 items on both)

7 Likes
3

Really great stuff! Thanks!

Also, @steven.harrington, I’m curious about the status of Bubble’s commitment to making operations more efficient from a WU-consumption perspective. For instance, what’s the status of the count is 0 issue, which has been discussed much on the forum and is nicely summarized in this article.

I mean, it wouldn’t be so bad if the most natural and intuitive way to check for an empty list wasn’t the most expensive by a factor of nearly 20.

It’s truly unfortunate that users of a no-code platform have to devote resources (time, mental, and money) to “optimizing” their app for this kind of thing when the optimization is actually needed at Bubble’s end.

:neutral_face:

15 Likes
4

Great improvements @steven.harrington :fire:

1 Like
5

Fantastic improvements!

Small question. Is catching errors in the backend on the roadmap?

We have a lovely catch error in frontend workflow.

Would really love to catch errors in backend and handle them. At the moment they fail silently and are very hard to work around.

We’ve had to resort to external health check systems and various dodgy workarounds.

Thanks
Zubair

8 Likes
6

These are exciting changes, great work Bubble team!

I wanted to ask where Create a List of Things we on this roadmap - and if it could be easily created from the inputs on a Repeating Group…

3 Likes
7

Add &backend_issue_checker=true to the editor url … but be prepared for the editor to become slower … :sweat:

8

I don’t mean editor errors but runtime errors.

Some API timed out
Some API glitched (openAI glitching a lot lately)

Cant easily catch and handle them all

5 Likes
9

@ZubairLK you can use Ncscale or Flusk to track those issues for now, it is working great, but I’m okay with you, we should have something natively.
There is so many bugs I ve fixed thanks to those third party tools.
Easy way to catch “app too busy” “timed out” and “workflow error”

1 Like
10

I like them.

But with that being said, I’d like @steven.harrington to consider something built-in

Thanks
Zubair

1 Like
11

What’s the limit on the Agency Plan? (it seems to still be 100 rows)

1 Like
12

Bubble Workflows are indeed very fast and very underrated.

Pee loading times and seo might keep us awake at night, but I honestly have no complaints with how fast workflows edit data.

1 Like
13

Thanks for calling this out! We’ve increased this by 10x as well, so should be 1k rows now.

1 Like
14

@sudsy yeah, very good point!

15

Anything in the works or on the roadmap for improving page load speed so that a Bubble app may be able to get satisfactory scores from Google Page Insights? It has been discussed for at least 5+ years now and Bubble has stated publicly they are focusing on it…just want to check if that is still happening or if it has been scrapped?

4 Likes
16

They said in BubbleCon not too long ago that it is a work in progress and it’s a ‘lots of small improvements’ under the hood kind of thing rather than ‘upgrade your Bubble version and get faster page load’

2 Likes
17

Fantastic to hear those improvements

18

Hi @steven.harrington

I was able to retrieve this reading from your post, and I want to say that these changes are wonderful. Congratulations to the Bubble team for all of this.

I have a question, see if you can clarify it for me please? With this whole process that involves even greater speed and row increase limits for uploading data into CSV files, what about the challenge of identifying and registering date and currency formats for countries that operate on a different standard than the US? Example: in the case of dates (from mm/dd/yy USA to dd/mm/yy Brazil) and currency (from USA 1,000 USA to 1,000 Brazil), also natively?

Currently this has been a serious dilemma.
hanks in advance