Database performance issue

jagdish_bajaj · 2024-09-24T14:16:12.330Z

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.

tunacardak · 2024-09-24T15:09:55.345Z

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

jagdish_bajaj · 2024-09-24T15:20:46.021Z

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

pierre6 · 2024-09-24T15:44:59.615Z

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 ?

jagdish_bajaj · 2024-09-24T16:11:06.413Z

@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.

pierre6 · 2024-09-24T16:42:43.592Z

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.

nate8 · 2024-09-24T16:44:37.553Z

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.

paritosh.mehta19 · 2024-09-25T09:00:15.454Z

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.

fede.bubble · 2024-09-25T12:12:13.825Z

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

Bubble

Bug Report

You know what they say about two (or three, or a thousand) sets of eyes being better than one. If something doesn’t seem to be working right with Bubble, use this form to let us know, and we’ll investigate. (Also: Thanks!).

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

dan8 · 2024-09-25T17:08:46.101Z

Same here.

Buge Report filed.

para.design · 2024-09-26T16:26:09.101Z

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.

Screenshot 2024-09-26 at 10.51.48 AM1124×860 40.5 KB

jagdish_bajaj · 2024-09-26T17:09:24.465Z

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?

pierre6 · 2024-09-26T17:42:58.802Z

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

nate8 · 2024-09-26T20:03:52.140Z

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?

jagdish_bajaj · 2024-09-26T20:18:26.664Z

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.

pierre6 · 2024-09-26T22:09:05.006Z

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.

jagdish_bajaj · 2024-09-26T22:14:22.241Z

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?

nate8 · 2024-09-27T03:52:28.227Z

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