Public chat for a large number of users

Need help Database
1

Hey!

I use my bubble app for online events with video streaming. I made a public chat for all users using a repeating group and a search in the message database. When there are more people at the event (~ 900) who actively write to the chat, it overloads my application due to frequent searches in the database.

Is it possible to display public chat differently? I don’t know how to code, but I’m sure there is a way to turn 900 regular call into one database. It seems that all users should just look at something like a frame that downloads messages once for everyone, but I don’t know how to do this in a bubble.

2

If it’s too much dB activity at once, you may consider a service like Firebase/firestore or upgrading for more capacity. A nosql database might be ideal for a large public forum like that.

It could simply be the way the blocks are configured. Does it go over on app capacity?

3

Now I use a professional plan with an additional 4 units and still have 90% CPU at the time of peak activity. And the rest of the workflows are not so many