Database performance issue

I am having performance issues on a large app.

Since yesterday morning, database performance has slowed considerably. Rendering a list of 10 items in a RG from a list field in the DB takes 20 seconds, when it used to be 1 to 2 seconds until last week. Anything to do with reading from the DB has slowed down. No new updates, no change in DB structure.

Filed a bug report with bubble support, and their investigation is ongoing.

Just curious - is anyone else experiencing something similar? Any and all thoughts welcome.

2 Likes

It is same when you see the data on the bubble data panel or it’s slow only on the preview mode?

Both - slow on the data panel as well as in Preview mode

Experiencing the same issue. It’s been a few days but has been increasingly slow since Saturday.

Most of the issues seems related to one datatype that contains 2 millions entries.

How’s capacity usage looking for you @jagdish_bajaj ?

@pierre6 - our issue also seems to be related to a single data type, even though it is not our largest and only has 1,000 entries. To overcome capacity throttling, we upgraded our plan to Growth (it would automatically upgrade on Oct 1 anyway) but that didn’t help either.

Same here, added a few capacity units to the app, made a few optimisation which reduced WU but those capacity spikes and the app overall slowness is still the same.

Currently waiting for a response from Bubble support.

Same here. I noticed it yesterday but figured it might be my internet connection. Kept checking the forum to see if anyone else was having an issue.

We are experiencing performance issues too. Just logged a bug report. In our case, it’s not data coming from the DB though, but instead all the data is via API’s. There is no degradation in the API performance (verified via POSTMAN).

One thing I have observed is that static.js & dynamic.js takes a long time to load - Not sure if you are seeing something similar - and hence we are seeing a blank page for a while before the actual API data becomes visible.

hi everyone, could you all please take a minute and submit a bug report?

The team will group all of them together and look at this together

1 Like

Same here.

Buge Report filed.

Thank you @jagdish_bajaj for lifting this up right away. I hope that the recent update on https://status.bubble.io/ is related and there is a swift recovery ahead.

1 Like

It looks like the database issue reported on the Status page at 11:20ET today was related to performance.

Now the Status page shows that the issue has been resolved but my client’s app is still experiencing the same slow performance that started on Monday. It is starting to wear those folks down since their business operation is severely impacted.

Is anyone here back to normal now?

2 Likes

Nope, still the same, performance was at its worse this afternoon.
Still waiting for an answer from Bubble support.

1 Like

I’ve been in contact with support but they haven’t provided any solutions. Going on 4 days and haven’t had any users actively using our site because of how slow it is.

Out of curiosity, is anyone else running on workload overages at the moment? As in, have you expended your workload credits for this month?

No, haven’t used up WU and here’s why:

The app I refer to in this thread was on a legacy plan. When we first encountered the performance issue on Monday, I figured we can upgrade it to the Growth plan (it would have happened on Oct 1 anyway). My guess was that we were being throttled by the legacy plan but that was incorrect. Performance hasn’t improved even with the new Growth WU-based plan.

2 Likes

On legacy plan too.
WU for the week are pretty much inline with the rest of the month, however server capacity has huge spikes.
The searches, and WF that are consuming a large amount of WU are not the same that the ones consuming a large amount of capacity.

For us also, WU is in line (more or less) with the rest of the month. On the day the problem started (Monday 22 Sep) WU was a bit higher but Mondays are like that, due to start of the week traffic.

Has anyone who filed a bug report heard back from bubble support?

1 Like

I have. They said they are aware and working on it, but haven’t had any updates since that.

1 Like